Results of 1 - 10 of about 40 for extract (0.004 sec.)
- Struct Functions 12310
- 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
...update and remap_struct , require a STRUCT . Name Description struct.entry Dot notation that serves as an alias for struct_extract from named STRUCT s. struct[entry] Bracket notation that serves as an alias for struct_extract from named STRUCT s. struct...[idx] Bracket notation that serves as an alias for struct_extract from TUPLE s, using an index (1-based). remap_struct(input, target_type, mapping, defaults) Remap a STRUCT , LIST , or MAP...ple 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 from the STRUCT . struct_extract(struct, idx) Extract the entry from a TUPLE usin... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Regular Expressions 12263
- 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
...ion syntax, see the RE2 docs . Functions All functions 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.... The group must be a constant value. If no group is given, 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 wi...th corresponding names from name_list ; otherwise, returns a struct with the same keys and empty strings as values. regexp_extract_all(string, regex[, group = 0][, options]) Finds non-overlapping occurrences of regex in string and returns the correspond... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Python Client API 11701
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...ckdb.DuckDBPyConnection Execute the given prepared statement multiple times using the list of parameter sets in parameters extract_statements ( self , query : str ) → list Parse the query string and extract the Statement object(s) produced fetch_df ( se...Get profiling information for a query get_table_names ( self , query : str , * , qualified : bool = False ) → set [ str ] Extract the required table names from a query install_extension ( self , extension : str , * , force_install : bool = False , repo...rlier expression API. json ( ) → JsonExpr This expression as JSON, with the string functions in scope too: col(“p”).json().extract(“$.id”) . kurtosis ( * args : ValueOrExpr ) → Expression The kurtosis of the distribution. SQL: kurtosis . last ( * args :... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Union Functions 10313
- 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
...e the currently selected tag of the union as an Enum . union.tag | Description | Dot notation serves as an alias for union_extract . | | Example | (union_value(k := 'hello')).k | | Result | hello | union_extract(union, 'tag') | Description | Extract the...value with the named tags from the union. NULL if the tag is not currently selected. | | Example | union_extract(s, 'k') | | Result | hello | union_value(tag := any) | Description | Create a single member UNION containing the argument... - https://man.mtool.work/duckdb/2.0/sql/functions/union.html
- Variant Functions 9798
- This section describes functions that operate on the VARIANT type . New Most variant_* functions were introduced in DuckDB 2.0. The variant_extract , variant_normalize and variant_typeof functions were already available in DuckDB 1.5. Name
...urn the top-level type category of a VARIANT value. variant_keys(v) Return the keys of a VARIANT object as a list. variant_extract(v, field) Extract a nested value by object field name or list index. Returns a VARIANT . variant_extract_string(v, field)...of a VARIANT object as a list. | | Example | variant_keys('{"a": 1, "b": 2}'::JSON::VARIANT) | | Result | [a, b] | variant_extract(v, field) | Description | Extract a nested value by object field name or list index. Returns a VARIANT . | | Example | var...iant_extract('{"name": "Fry"}'::JSON::VARIANT, 'name') | | Result | Fry | variant_extract_string(v, field) | Description | Extract a ne... - https://man.mtool.work/duckdb/2.0/sql/functions/variant.html
- JSON Processing Functions 9704
- JSON Extraction Functions There are two extraction functions, which have their respective operators. The operators can only be used if the string is stored as the JSON logical type. These functions support the same two location notations as
...rator Description json_exists(json, path) Returns true if the supplied path exists in the json , and false otherwise. json_extract(json, path) json_extract_path -> Extracts JSON from json at the given path . If path is a LIST , the result will be a LIST...of JSON . json_extract_string(json, path) json_extract_path_text ->> Extracts VARCHAR from json at the given path . If path is a LIST , the resul...t will be a LIST of VARCHAR . json_value(json, path) Extracts JSON from json at the given path . If the json at the supplied path is not a scalar value, it will return NULL . Note tha... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
- Map Functions 8862
- 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
...ks if a map contains a given value. map_entries(map) Return a list of struct(k, v) for each key-value 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 prov...keys; else, an error is thrown. | | Example | element_at(map([100, 5], [42, 43]), 100) | | Result | [42] | | Aliases | map_extract(map, key) | map_concat(maps...) | Description | Returns a map created from merging the input maps . On key collision the v... - https://man.mtool.work/duckdb/2.0/sql/functions/map.html
- Interval Functions 8581
- This section describes functions and operators for examining and manipulating INTERVAL values. Interval Operators The table below shows the available mathematical operators for INTERVAL types. Operator Description Example Result + Addition
...ctions The table below shows the available scalar functions for INTERVAL types. Name Description date_part(part, interval) Extract datepart component (equivalent to extract ). See INTERVAL for the sometimes surprising rules governing this extraction. da...tepart(part, interval) Alias of date_part . extract(part FROM interval) Alias of date_part . epoch(interval) Get total number of seconds, as double precision floating point n...ar interval. Only the documented date part components are defined for intervals. date_part(part, interval) | Description | Extract datepart component (equivalent to extract ). See INTERVAL for the sometimes surprising rules governing this extraction. |... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
- Text Functions 8393
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...ts, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list1, list2, ...) . array_extract(string, index) Extracts a single character from a string using a (1-based) index . array_slice(list, begin, end) Extracts...ppercase characters are considered smaller than lowercase characters and collations are not supported. left(string, count) Extracts the left-most count characters. left_grapheme(string, count) Extracts the left-most count grapheme clusters. len(string)...tring) Escapes special patterns to turn string into a regular expression similarly to Python's re.escape function . regexp_extract(string, regex[, group][, options]) If string contains the regex pattern, returns the capturing group specified by optional... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Time Functions 8347
- This section describes functions and operators for examining and manipulating TIME values . Time Operators The table below shows the available mathematical operators for TIME types. Operator Description Example Result + addition of an INTER
...ndtime , inclusive of the larger time and exclusive of the smaller time. date_part(part, time) Get subfield (equivalent to extract ). date_sub(part, starttime, endtime) The signed length of the interval between starttime and endtime , truncated to whole...multiples of part . extract(part FROM time) Get subfield from a time. get_current_time() Current time (start of current transaction). make_time(bigint..., TIME '06:01:03') | | Result | 5 | | Alias | datediff | date_part(part, time) | Description | Get subfield (equivalent to extract ). | | Example | date_part('minute', TIME '14:21:13') | | Result | 21 | | Alias | datepart | date_sub(part, starttime, end... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
DuckDB 2.0 Documentation / man.mtool.work