Results of 1 - 10 of about 98 for contains (0.003 sec.)
- Information Schema 14282
- 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
...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 scale indicates the number of digits after the decimal p...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/2.0/sql/meta/information_schema.html
- DuckDB_% Metadata Functions 12205
- 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
...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/2.0/sql/meta/duckdb_table_functions.html
- Map Functions 11930
- Name Description cardinality(map) Return the size of the map (or the number of 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 ke
...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...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, 'k... - https://man.mtool.work/duckdb/2.0/sql/functions/map.html
- EXPORT and IMPORT DATABASE Statements 8885
- The EXPORT DATABASE command allows you to export the contents of the database to a specific directory. The IMPORT DATABASE command allows you to then read the contents again. Examples Export the database to the target directory target_direc
...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...OM DATABASE does not copy them either. Recreate triggers manually after importing or copying a 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...schema.sql uses plain CREATE statements (without OR REPLACE or IF NOT EXISTS ), so importing into a database that already contains any of the exported objects – for example a user-defined type – fails with a "already exists" error. Import into an empty... - https://man.mtool.work/duckdb/2.0/sql/statements/export.html
- Regular Expressions 8676
- DuckDB offers pattern matching operators ( LIKE , SIMILAR TO , GLOB ), as well as support for regular expressions via functions. Regular Expression Syntax DuckDB uses the RE2 library as its regular expression engine. For the regular express
...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/2.0/sql/functions/regular_expressions.html
- List Functions 8611
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...m . array_cat(list_1, ..., list_n) Alias for list_concat . array_concat(list_1, ..., list_n) Alias for list_concat . array_contains(list, element) Alias for list_contains . array_distinct(list) Alias for list_distinct . array_extract(list, index) Extract...s for list_filter . array_grade_up(list[, col1][, col2]) Alias for list_grade_up . array_has(list, element) Alias for list_contains . array_has_all(list1, list2) Alias for list_has_all . array_has_any(list1, list2) Alias for list_has_any . array_indexof(...as for length . concat(value, ...) Concatenates multiple strings or lists. NULL inputs are skipped. See also operator || . contains(list, element) Returns true if the list contains the element . filter(list, lambda(x)) Alias for list_filter . flatten(nes... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Struct Functions 7984
- 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
...a TUPLE containing the argument values. struct_concat(structs...) Merge the multiple structs into a single STRUCT . struct_contains(struct, entry) Check if the STRUCT contains the specified entry. struct_extract(struct, 'entry') Extract the named entry f.... | | Example | struct_concat(struct_pack(i := 4), struct_pack(s := 'string')) | | Result | {'i': 4, 's': string} | struct_contains(struct, entry) | Description | Check if the STRUCT contains the specified entry. | | Example | struct_contains(row(1, 2, 3... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Spatial Functions 7644
- 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
...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 \"p...roperly\" contains the second geometry ST_ConvexHull Returns the convex hull enclosing the geometry ST_CoverageInvalidEdges Returns the inval...INESTRING 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/2.0/core_extensions/spatial/functions.html
- SQLite Extension 7579
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...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/2.0/core_extensions/sqlite.html
- Constraints 7500
- In SQL, constraints can be specified for tables. Constraints enforce certain properties over data that is inserted into a table. Constraints can be specified along with the schema of the table as part of the CREATE TABLE statement . In cert
...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, ' '))); INSERT I...NTO students VALUES ('this name contains spaces'); Constraint Error: CHECK constraint failed on table students with expression CHECK((NOT contains("name", ' '))) N...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 student... - https://man.mtool.work/duckdb/2.0/sql/constraints.html
DuckDB 2.0 Documentation / man.mtool.work