Results of 1 - 10 of about 43 for containing (0.006 sec.)
- Values 15425
- The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const ch
...e from a uhugeint Syntax duckdb_value duckdb_create_uuid ( duckdb_uhugeint input ); Parameters input : The duckdb_uhugeint containing the UUID Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_get_bool Returns the boolean va...lue of the given value. Syntax bool duckdb_get_bool ( duckdb_value val ); Parameters val : A duckdb_value containing a boolean Return Value A boolean, or false if the value cannot be converted duckdb_get_int8 Returns the int8_t value of th...e given value. Syntax int8_t duckdb_get_int8 ( duckdb_value val ); Parameters val : A duckdb_value containing a tinyint Return Value A int8_t, or MinValue if the value cannot be converted duckdb_get_uint8 Returns the uint8_t value o... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Aggregate Functions 10720
- 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
...This function is affected by ordering . arg_max(arg, val, n) The generalized case of arg_max for n values: returns a LIST containing the arg expressions for the top n rows ordered by val descending. This function is affected by ordering . arg_max_null(arg...re val is NULL are sorted last, i.e., they are only selected if there are no other rows. If n is specified, returns a LIST containing the arg expressions for the top n rows ordered by val descending, with NULL values of val last. This function is affected...the arg or val expression is NULL are ignored. This function is affected by ordering . arg_min(arg, val, n) Returns a LIST containing the arg expressions for the "bottom" n rows ordered by val ascending. This function is affected by ordering . arg_min_null... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Complete API 10350
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...alog.schema.table), if set to true, else only the (not escaped) table names. Return Value A duckdb_value of type VARCHAR[] containing the (fully qualified) table names of the query. Must be destroyed with duckdb_destroy_value. duckdb_create_config Initiali...e from a uhugeint Syntax duckdb_value duckdb_create_uuid ( duckdb_uhugeint input ); Parameters input : The duckdb_uhugeint containing the UUID Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_get_bool Returns the boolean va...lue of the given value. Syntax bool duckdb_get_bool ( duckdb_value val ); Parameters val : A duckdb_value containing a boolean Return Value A boolean, or false if the value cannot be converted duckdb_get_int8 Returns the int8_t value of th... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Spatial Functions 10073
- 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
...es from a GeometryCollection into a typed multi geometry. ST_ConcaveHull Returns the 'concave' hull of the input geometry, containing all of the source input's points, and which can be used to create polygons from points. The ratio parameter dictates the l...convex hull; and 0 indicates to return the most concave hull possible. Set allowHoles to a non-zero value to allow output containing holes. ST_Contains Returns true if the first geometry contains the second geometry ST_ContainsProperly Returns true if the...ing Returns a substring of a line between two fractions of total 2D length. ST_LocateAlong Returns a point or multi-point, containing the point(s) at the geometry with the given measure ST_LocateBetween Returns a geometry or geometry collection created by... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Information Schema 9240
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...of_use Character encoding form, same as the database encoding. VARCHAR 'UTF8' default_collate_catalog Name of the database containing the default collation (always the current database). VARCHAR 'my_db' default_collate_schema Name of the schema containing...s present in the database and has the following layout: Column Description Type Example table_catalog Name of the database containing the table (always the current database). VARCHAR 'my_db' table_schema Name of the schema containing the table. VARCHAR 'ma...referential_constraints : Referential Constraints Column Description Type Example constraint_catalog Name of the database containing the constraint (always the current database). VARCHAR 'my_db' constraint_schema Name of the schema containing the constrai... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- Union Functions 8684
- Name Description union.tag Dot notation serves as an alias for union_extract . union_extract(union, 'tag') Extract the value with the named tags from the union. NULL if the tag is not currently selected. union_value(tag := any) Create a sin
...gle member UNION containing the argument value. The tag of the value will be the bound variable name. union_tag(union) Retrieve the currently selected...Example | union_extract(s, 'k') | | Result | hello | union_value(tag := any) | Description | Create a single member UNION containing the argument value. The tag of the value will be the bound variable name. | | Example | union_value(k := 'hello') | | Resu... - https://man.mtool.work/duckdb/2.0/sql/functions/union.html
- Struct Functions 8592
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unna
...d reordering fields, descending into nested types, and filling missing fields from defaults . row(any, ...) Create a TUPLE containing the argument values. struct_concat(structs...) Merge the multiple structs into a single STRUCT . struct_contains(struct, e.... struct_keys(struct) Return the names of the entries of a STRUCT as a list. struct_pack(name := any, ...) Create a STRUCT containing the argument values. The entry name will be the bound variable name. struct_position(struct, entry) Return the index of th...he mapping key 'list' , and a MAP 's children by the keys 'key' and 'value' . row(any, ...) | Description | Create a TUPLE containing the argument values. | | Example | row(i, i % 4, i / 4) | | Result | (10, 2, 2.5) | struct_concat(structs...) | Descriptio... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Excel Extension 8221
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...ers are supported. Option Type Default Description header BOOLEAN automatically inferred Whether to treat the first row as containing the names of the resulting columns. sheet VARCHAR automatically inferred The name of the sheet in the xlsx file to read. D...efault is the first sheet. all_varchar BOOLEAN false Whether to read all cells as containing VARCHAR s. ignore_errors BOOLEAN false Whether to ignore errors and silently replace cells that can't be cast to the corre...: TIMESTAMP , TIME , DATE and BOOLEAN types are inferred when possible based on the format applied to the cell. Text cells containing TRUE and FALSE are inferred as BOOLEAN . Empty cells are considered to be DOUBLE by default, unless the empty_as_varchar o... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- DuckDB_% Metadata Functions 8129
- 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
...tabase_name The name of the database that contains this function. VARCHAR database_oid Internal identifier of the database containing the index. BIGINT schema_name The SQL name of the schema where the function resides. VARCHAR function_name The SQL name of...database_name The name of the database that contains this index. VARCHAR database_oid Internal identifier of the database containing the index. BIGINT schema_name The SQL name of the schema that contains the table with the secondary index. VARCHAR schema_...database_name The name of the database that contains this schema. VARCHAR database_oid Internal identifier of the database containing the schema. BIGINT schema_name The SQL name of the schema. VARCHAR comment A comment created by the COMMENT ON statement .... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Date Part Functions 7944
- The date_part , date_trunc and date_diff functions can be used to extract or manipulate parts of temporal types such as TIMESTAMP , TIMESTAMPTZ , DATE and INTERVAL . The parts to be extracted or manipulated are specified by one of the strin
...(CE/AD, BCE/BC) 1 isodow ISO day of the week (Monday = 1, Sunday = 7) 2 isoyear ISO Year number (Starts on Monday of week containing Jan 4th) 2021 julian Julian Day number. 2459430.4998162435 timezone_hour Time zone offset hour portion 0 timezone_minute T...Hours. isodow(date) Numeric ISO weekday (Monday = 1, Sunday = 7). isoyear(date) ISO Year number (Starts on Monday of week containing Jan 4th). julian(date) DOUBLE Julian Day number. microsecond(date) Sub-minute microseconds. millennium(date) Millennium. m...ample | isodow(DATE '1992-02-15') | | Result | 6 | isoyear(date) | Description | ISO Year number (Starts on Monday of week containing Jan 4th). | | Example | isoyear(DATE '2022-01-01') | | Result | 2021 | julian(date) | Description | DOUBLE Julian Day numb... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
DuckDB 2.0 Documentation / man.mtool.work