Results of 1 - 10 of about 18 for contained (0.005 sec.)
- Map Functions – DuckDB 14310
- 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
...f entries in the map). element_at(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is...alue pair in the map. map_extract(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is...thrown. map_extract_value(map, key) Returns the value for a given key or NULL if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- Querying Parquet Metadata – DuckDB 11513
- 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
...s Copy Markdown Querying Parquet Metadata Parquet Metadata The parquet_metadata function can be used to query the metadata contained within a Parquet file, which reveals various internal details of the Parquet file such as the statistics of the different..._is_exact BOOLEAN max_is_exact BOOLEAN Parquet Schema The parquet_schema function can be used to query the internal schema contained within a Parquet file. Note that this is the schema as it is contained within the metadata of the Parquet file. If you wan...t to figure out the column names and types contained within a Parquet file it is easier to use DESCRIBE . Fetch the column names and column types: DESCRIBE SELECT * FROM 'test... - https://man.mtool.work/duckdb/1.3/data/parquet/metadata.html
- Map Type – DuckDB 9505
- 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
...'key2' : 43 }[ 'key1' ]; 5 If the key has the wrong type, an error is thrown. If it has the correct type but is merely not contained in the map, a NULL value is returned. SELECT MAP { 'key1' : 5 , 'key2' : 43 }[ 'key3' ]; NULL The map_extract function (an...d its synonym element_at ) can be used to retrieve a value wrapped in a list; it returns an empty list if the key is not contained in the map: SELECT map_extract ( MAP { 'key1' : 5 , 'key2' : 43 }, 'key1' ); [5] SELECT MAP { 'key1' : 5 , 'key2' : 43 }[...連キーワード values keys nested type types list comparison also using extract ordered need single Keys bracket Maps entries contained used compare rules member Functions Documentation Types 関連するページ Data Types Map Functions Struct Data Type Nested Fu... - https://man.mtool.work/duckdb/1.3/sql/data_types/map.html
- Overview – DuckDB 9042
- 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
...ion of the DuckDB C API is 1.5.6. DuckDB implements a custom C API modeled somewhat following the SQLite C API. The API is contained in the duckdb.h header. Continue to Startup & Shutdown to get started, or check out the Full API overview . We also provid...DuckDB SQLite wrapper Documentation Client APIs Copy Markdown Overview latest implements custom modeled somewhat following contained duckdb header Continue Startup Shutdown started check overview also 関連するページ SQLite Import SQLite Extension Document... - https://man.mtool.work/duckdb/1.3/clients/c/overview.html
- Spatial Functions – DuckDB 9042
- 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
...Returns true if the first geometry is within the second ST_WithinProperly Returns true if the first geometry "properly" is contained by the second geometry ST_X Returns the X coordinate of a point geometry ST_XMax Returns the maximum X coordinate of a geo...no type parameters is provided, the function will return a multi geometry matching the highest "surface dimension" of the contained geometries. E.g. if the collection contains only Points, a MultiPoint will be returned. But if the collection contains bot...ings, a MultiLineString will be returned. Similarly, if the collection contains Polygons, a MultiPolygon will be returned. Contained geometries of a lower surface dimension will be ignored. If the input geometry contains nested GeometryCollections, their... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Pattern Matching – DuckDB 8407
- 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
...* ) to match zero or more characters. In addition, you can use the bracket syntax ( [...] ) to match any single character contained within the brackets, or within the character range specified by the brackets. An exclamation mark ( ! ) may be used inside...the first bracket to search for a character that is not contained within the brackets. To learn more, visit the “glob (programming)” Wikipedia page . GLOB The GLOB operator returns true or... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- C++ API – DuckDB 8253
- 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
...successful, other fields are set: the type of statement that was just executed (e.g., StatementType::INSERT_STATEMENT ) is contained in statement_type . The high-level (“Logical type”/“SQL type”) types of the result set columns are in types . The names of...sult columns are in the names string vector. In case multiple result sets are returned, for example because the result set contained multiple statements, the result set can be chained using the next field. DuckDB also supports prepared statements in the C... - https://man.mtool.work/duckdb/1.3/clients/cpp.html
- Query – DuckDB 8098
- 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
.... col : The column index. Return Value The nullmask of the specified column. duckdb_result_error Returns the error message contained within the result. The error is only set if duckdb_query returns DuckDBError . The result of this function must not be fre...ject to fetch the error from. Return Value The error of the result. duckdb_result_error_type Returns the result error type contained within the result. The error is only set if duckdb_query returns DuckDBError . Syntax duckdb_error_type duckdb_result_erro... - https://man.mtool.work/duckdb/1.3/clients/c/query.html
- Loading JSON – DuckDB 8098
- 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
...he keys and data types of the values automatically BOOL true columns A struct that specifies the key names and value types contained within the JSON file (e.g., {key1: 'INTEGER', key2: 'VARCHAR'} ). If auto_detect is enabled these will be inferred STRUCT...e keys and data types of the values automatically BOOL false columns A struct that specifies the key names and value types contained within the JSON file (e.g., {key1: 'INTEGER', key2: 'VARCHAR'} ). If auto_detect is enabled these will be inferred STRUCT... - https://man.mtool.work/duckdb/1.3/data/json/loading_json.html
- Complete API – DuckDB 7635
- 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
.... col : The column index. Return Value The nullmask of the specified column. duckdb_result_error Returns the error message contained within the result. The error is only set if duckdb_query returns DuckDBError . The result of this function must not be fre...ject to fetch the error from. Return Value The error of the result. duckdb_result_error_type Returns the result error type contained within the result. The error is only set if duckdb_query returns DuckDBError . Syntax duckdb_error_type duckdb_result_erro...Return Value DuckDBSuccess on success or DuckDBError on failure. duckdb_extract_statements_error Returns the error message contained within the extracted statements. The result of this function must not be freed. It will be cleaned up when duckdb_destroy_... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
DuckDB 1.3 Documentation / man.mtool.work