Results of 1 - 7 of about 7 for boundary (0.003 sec.)
- Enum Functions 12814
- This section describes functions and operators for examining and manipulating ENUM values . The examples assume an enum type created as: CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy', 'anxious'); These functions can take NULL or a specific
...turn a value that depends only on the type of the argument, and not on its value. The functions enum_code() and enum_range_boundary() are exceptions; they return a value that depends on the argument value, as well as its type. Name Description enum_code(...the last value of the input enum type. enum_range(enum) Returns all values of the input enum type as an array. enum_range_boundary(enum, enum) Returns the range between the two given enum values as an array. enum_code(enum_value) | Description | Returns...the input enum type as an array. | | Example | enum_range(NULL::mood) | | Result | [sad, ok, happy, anxious] | enum_range_boundary(enum, enum) | Description | Returns the range between the two given enum values as an array. The values must be of the sam... - https://man.mtool.work/duckdb/2.0/sql/functions/enum.html
- Spatial Functions 10687
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...a GeoJSON fragment ST_AsHEXWKB Returns the geometry as a HEXWKB string ST_AsMVTGeom Transform and clip geometry to a tile boundary ST_AsSVG Convert the geometry into a SVG fragment or path ST_AsText Returns the geometry as a WKT string ST_AsWKB Returns...Well-Known-Binary) blob ST_Azimuth Returns the azimuth (a clockwise angle measured from north) of two points in radian. ST_Boundary Returns the "boundary" of a geometry ST_Buffer Returns a buffer around the input geometry at the target distance ST_BuildA..._2D, extent BIGINT) GEOMETRY ST_AsMVTGeom (geom GEOMETRY, bounds BOX_2D) Description Transform and clip geometry to a tile boundary See ST_AsMVT for more details ST_AsSVG Signature VARCHAR ST_AsSVG (geom GEOMETRY, relative BOOLEAN, precision INTEGER) Des... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Aggregate Functions 8542
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...per boundaries and counts of elements in the corresponding bins (left-open and right-closed partitions) of the datatype. A boundary at the largest value of the datatype is automatically added when elements larger than all provided boundaries appear, see...n . histogram_values(source, col_name, technique, bin_count) A table macro (not an aggregate function) returning the upper boundary of each bin and its count for a column; see the detailed entry for the available technique values. last(arg) Returns the l...per boundaries and counts of elements in the corresponding bins (left-open and right-closed partitions) of the datatype. A boundary at the largest value of the datatype is automatically added when elements larger than all provided boundaries appear, see... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Window Functions 8415
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
...computing a new column for each row as a function of the nearby values. Some window functions depend only on the partition boundary and the ordering, but a few (including all the aggregates) also use a frame . Frames are specified as a number of rows on...a RANGE specification, there must be only one ordering expression and it must support subtraction unless only the sentinel boundary values UNBOUNDED PRECEDING / UNBOUNDED FOLLOWING / CURRENT ROW are used. Using the EXCLUDE clause , rows comparing equal t...sent and RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW when an ORDER BY clause is present. By default, the CURRENT ROW boundary value (but not the CURRENT ROW in the EXCLUDE clause) means the current row and all its peers when RANGE or GROUP framing... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
- Utility Functions 7979
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...the "catch-all element" of its datatype for the purpose of the histogram_exact function, which is equal to the "right-most boundary" of its datatype for the purpose of the histogram function. make_type(name, ...) Constructs a value of type TYPE from a ty...the "catch-all element" of its datatype for the purpose of the histogram_exact function, which is equal to the "right-most boundary" of its datatype for the purpose of the histogram function. | | Example | is_histogram_other_bin('') | | Result | true | m... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Reference 7706
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...nline in the PREPARE response before the remainder is left to FETCH . Drains whole batches, so it may overshoot to a batch boundary. quack_fetch_read_ahead UBIGINT 0 Number of FETCH requests the client keeps in flight ahead of the scan. 0 uses the number... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- DuckDB_% Metadata Functions 7415
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
..., or NULL if a value was never drawn from the sequence. If the sequence cycles, then the sequence will start over from the boundary of its range, not necessarily from the value specified as start value. duckdb_settings The duckdb_settings() function prov... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work