Results of 1 - 10 of about 43 for containing (0.011 sec.)
- Values – DuckDB 15040
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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/1.3/clients/c/value.html
- Aggregate Functions – DuckDB 11862
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...at Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Aggregate Functions 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...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...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/1.3/sql/functions/aggregates.html
- Complete API – DuckDB 10504
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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/1.3/clients/c/api.html
- Struct Functions – DuckDB 9348
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...or struct_extract from unnamed STRUCT s (tuples), using an index (1-based). row(any, ...) Create an unnamed STRUCT (tuple) containing the argument values. struct_concat(structs...) Merge the multiple structs into a single STRUCT . struct_extract(struct, 'e...h the argument values. The entry name(s) will be the bound variable name(s). struct_pack(name := any, ...) Create a STRUCT containing the argument values. The entry name will be the bound variable name. struct.entry Description Dot notation that serves as...), using an index (1-based). Example (row(42, 84))[1] Result 42 row(any, ...) Description Create an unnamed STRUCT (tuple) containing the argument values. Example row(i, i % 4, i / 4) Result (10, 2, 2.5) struct_concat(structs...) Description Merge the mult... - https://man.mtool.work/duckdb/1.3/sql/functions/struct.html
- Information Schema – DuckDB 8962
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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...n 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/1.3/sql/meta/information_schema.html
- Relational API – DuckDB 8777
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
..., default: False Interpret binary columns as strings instead of blobs. file_row_number : bool, default: False Add a column containing the row number within each file. filename : bool, default: False Add a column containing the name of the file each row cam...ion Create a relation object from the JSON file in 'name' Parameters path_or_buffer : object File path or file-like object containing JSON data to be read. columns : object Optional list of column names to project from the JSON data. sample_size : object N..., default: False Interpret binary columns as strings instead of blobs. file_row_number : bool, default: False Add a column containing the row number within each file. filename : bool, default: False Add a column containing the name of the file each row cam... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Spatial Functions – DuckDB 8576
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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...ile maintaining coverage ST_Envelope_Agg Alias for ST_Extent_Agg . ST_Extent_Agg Computes the minimal-bounding-box polygon containing the set of input geometries ST_Intersection_Agg Computes the intersection of a set of geometries ST_MemUnion_Agg Computes... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Union Functions – DuckDB 8484
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...named tags from the union. NULL if the tag is not currently selected. union_value(tag := any) Create a single member UNION containing the argument value. The tag of the value will be the bound variable name. union_tag(union) Retrieve the currently selected...ntly 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') Result 'hello'...scription extract currently selected Example hello Functions notation serves alias Extract named tags Create single member containing argument bound variable Retrieve Enum Documentation Copy 関連するページ Struct Functions Union Type Avro Extension Regular... - https://man.mtool.work/duckdb/1.3/sql/functions/union.html
- DuckDB_% Metadata Functions – DuckDB 8391
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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/1.3/sql/meta/duckdb_table_functions.html
- Array Functions – DuckDB 8005
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Y -native functions are also supported. Array-Native Functions Function Description array_value(arg1, ...) Create an ARRAY containing the argument values. array_cross_product(array1, array2) Compute the cross product of two arrays of size 3. The array elem...rray1, array2) Alias for array_negative_inner_product(array1, array2) . array_value(arg1, ...) Description Create an ARRAY containing the argument values. Example array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT) Result [1.0, 2.0, 3.0] array_cross_product(ar...Description between long arguments distance negative Example similarity cross equivalent Alias Functions functions Create containing argument values Documentation 関連するページ List Functions Time Functions Vector Similarity Search Extension Timestamp Fu... - https://man.mtool.work/duckdb/1.3/sql/functions/array.html
DuckDB 1.3 Documentation / man.mtool.work