Results of 1 - 10 of about 85 for contains (0.005 sec.)
- Information Schema – DuckDB 14322
- 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
...bove) and the character encoding. INTEGER 1073741824 numeric_precision If data_type identifies a numeric type, this column contains the (declared or implicit) precision of the type for this column. The precision indicates the number of significant digits...r all other data types, this column is NULL . INTEGER 18 numeric_scale If data_type identifies a numeric type, this column contains the (declared or implicit) scale of the type for this column. The precision indicates the number of significant digits. Fo...lumn is NULL . INTEGER 2 datetime_precision If data_type identifies a date, time, timestamp, or interval type, this column contains the (declared or implicit) fractional seconds precision of the type for this column, that is, the number of decimal digits... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- DuckDB_% Metadata Functions – DuckDB 12485
- 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
...ta about the columns available in the DuckDB instance. Column Description Type database_name The name of the database that contains the column object. VARCHAR database_oid Internal identifier of the database that contains the column object. BIGINT schema..._name The SQL name of the schema that contains the table object that defines this column. VARCHAR schema_oid Internal identifier of the schema object that contains the t...bout the constraints available in the DuckDB instance. Column Description Type database_name The name of the database that contains the constraint. VARCHAR database_oid Internal identifier of the database that contains the constraint. BIGINT schema_name... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Map Functions – DuckDB 12039
- 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
...turns a map created from merging the input maps . On key collision the value is taken from the last map with that key. map_contains(map, key) Checks if a map contains a given key. map_contains_entry(map, key, value) Check if a map contains a given key-va...lue pair. map_contains_value(map, value) Checks if a map contains a given value. map_entries(map) Return a list of struct(k, v) for each key-valu...Example map_concat(MAP {'key1': 10, 'key2': 20}, MAP {'key3': 30}, MAP {'key2': 5}) Result {key1=10, key2=5, key3=30} map_contains(map, key) Description Checks if a map contains a given key. Example map_contains(MAP {'key1': 10, 'key2': 20, 'key3': 30},... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- Regular Expressions – DuckDB 9080
- 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
...ons accept an optional set of options . Name Description regexp_extract(string, pattern[, group = 0][, options]) If string contains the regexp pattern , returns the capturing group specified by optional parameter group ; otherwise, returns the empty stri...n, it defaults to 0. A set of optional options can be set. regexp_extract(string, pattern, name_list[, options]) If string contains the regexp pattern , returns the capturing groups as a struct with corresponding names from name_list ; otherwise, returns...]) Returns true if the entire string matches the regex . regexp_matches(string, pattern[, options]) Returns true if string contains the regexp pattern , false otherwise. regexp_replace(string, pattern, replacement[, options]) If string contains the regex... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Spatial Functions – DuckDB 8269
- 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
...ndicates 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 first geometry "pr...operly" contains the second geometry ST_ConvexHull Returns the convex hull enclosing the geometry ST_CoverageInvalidEdges Returns the inval...LTILINESTRING is returned. If all geometries are POLYGON 's, a MULTIPOLYGON is returned. Otherwise if the input collection contains a mix of geometry types, a GEOMETRYCOLLECTION is returned. Empty and NULL geometries are ignored. If all geometries are em... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- EXPORT and IMPORT DATABASE Statements – DuckDB 8188
- 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
...t_directory/schema.sql target_directory/load.sql target_directory/t_1.csv ... target_directory/t_n.csv The schema.sql file contains the schema statements that are found in the database. It contains any CREATE SCHEMA , CREATE TABLE , CREATE VIEW and CREAT...E SEQUENCE commands that are necessary to re-construct the database. The load.sql file contains a set of COPY statements that can be used to read the data from the CSV files again. The file contains a single COPY state...by load.sql to re-load the data. Syntax 関連キーワード directory target database schema again command Export Parquet load contains contents files tables Statements allows specific read using serialized parquet statements found Syntax Documentation Copy... - https://man.mtool.work/duckdb/1.3/sql/statements/export.html
- Expression API – DuckDB 8039
- 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
...nt64 │ ├───────┼───────┤ │ 1 │ 42 │ │ 2 │ 21 │ │ 3 │ 13 │ │ 4 │ 14 │ └───────┴───────┘ Constant Expression This expression contains a single value. import duckdb import pandas as pd df = pd . DataFrame ({ 'a' : [ 1 , 2 , 3 , 4 ], 'b' : [ True , None , Fa...─┐ │ 'hello' │ │ varchar │ ├─────────┤ │ hello │ │ hello │ │ hello │ │ hello │ └─────────┘ Case Expression This expression contains a CASE WHEN (...) THEN (...) ELSE (...) END expression. By default ELSE is NULL and it can be set using .else(value = ...)...llo │ │ world │ │ hello │ └──────────────────────────────────────────────────────────┘ Function Expression This expression contains a function call. It can be constructed by providing the function name and an arbitrary amount of Expressions as arguments.... - https://man.mtool.work/duckdb/1.3/clients/python/expression.html
- SQLite Extension – DuckDB 7972
- 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
...ce a specific column type mapping. DuckDB follows SQLite's type affinity rules with a few extensions. If the declared type contains the string INT then it is translated into the type BIGINT If the declared type of the column contains any of the strings C...HAR , CLOB , or TEXT then it is translated into VARCHAR . If the declared type for a column contains the string BLOB or if no type is specified then it is translated into BLOB . If the declared type for a column contains an...then it is translated into DOUBLE . If the declared type is DATE , then it is translated into DATE . If the declared type contains the string TIME , then it is translated into TIMESTAMP . If none of the above apply, then it is translated into VARCHAR .... - https://man.mtool.work/duckdb/1.3/core_extensions/sqlite.html
- List Functions – DuckDB 7972
- 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
...ent) Appends element to list . list_concat(list1, ..., listn) Concatenate lists. NULL inputs are skipped. See also || list_contains(list, element) Returns true if the list contains the element. list_cosine_similarity(list1, list2) Compute the cosine simi...at exist in both l1 and l2 , without duplicates. list_position(list, element) Returns the index of the element if the list contains the element. If the element is not found, it returns NULL . list_prepend(element, list) Prepends element to list . list_re...nt of the input list. See the Lambda Functions page for more details. list_resize(list, size[, value]) Resizes the list to contain size elements. Initializes new elements with value or NULL if value is not set. list_reverse_sort(list) Sorts the elements... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Constraints – DuckDB 7823
- 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
...ns that do not satisfy this expression violate the constraint. For example, we could enforce that the name column does not contain spaces using the following CHECK constraint. CREATE TABLE students ( name VARCHAR CHECK ( NOT contains ( name , ' ' ))); IN...SERT INTO students VALUES ( 'this name contains spaces' ); Constraint Error: CHECK constraint failed on table students with expression CHECK((NOT contains("name", ' ')))...row in the table. The constraint enforces that the specified columns are unique within a table, i.e., that at most one row contains the given values for the set of columns. CREATE TABLE students ( id INTEGER PRIMARY KEY , name VARCHAR ); INSERT INTO stud... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
DuckDB 1.3 Documentation / man.mtool.work