Results of 1 - 10 of about 32 for Extract (0.010 sec.)
- Struct Functions – DuckDB 13403
- 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
...L / Functions Copy Markdown Struct Functions 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 unnamed STRUCT s (tuples), using an index (1-based). row(any, ...) Create an unnamed STRUCT (tuple) containing the ar...gument values. struct_concat(structs...) Merge the multiple structs into a single STRUCT . struct_extract(struct, 'entry') Extract the named entry from the STRUCT . struct_extract(struct, idx) Extract the entry from an unnamed S... - https://man.mtool.work/duckdb/1.3/sql/functions/struct.html
- Regular Expressions – DuckDB 12436
- 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
...expression 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/1.3/sql/functions/regular_expressions.html
- JSON Processing Functions – DuckDB 10729
- 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
...ution Format Pivot Sitemap Live Demo Documentation / Data Import / JSON Files Copy Markdown JSON Processing Functions JSON Extraction Functions There are two extraction functions, which have their respective operators. The operators can only be used if...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... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Union Functions – DuckDB 9810
- 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
...ation / SQL / Functions Copy Markdown Union Functions 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 selec...rieve 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 string union_extract(union, 'tag') Description Extract the value with the n...amed 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 value. The t... - https://man.mtool.work/duckdb/1.3/sql/functions/union.html
- Map Functions – DuckDB 8957
- 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
...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...type of the map's 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 value i... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- Time Functions – DuckDB 8957
- 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
...tarttime, endtime) The number of partition boundaries between the times. date_part(part, time) Get subfield (equivalent to extract ). date_sub(part, starttime, endtime) The number of complete partitions between the times. datediff(part, starttime, endti...The number of partition boundaries between the times. datepart(part, time) Alias of date_part. Get subfield (equivalent to extract ). datesub(part, starttime, endtime) Alias of date_sub. The number of complete partitions between the times. extract(part...date_diff('hour', TIME '01:02:03', TIME '06:01:03') Result 5 date_part(part, time) Description Get subfield (equivalent to extract ). Example date_part('minute', TIME '14:21:13') Result 21 date_sub(part, starttime, endtime) Description The number of com... - https://man.mtool.work/duckdb/1.3/sql/functions/time.html
- Date Functions – DuckDB 8892
- 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
...date, enddate) The number of partition boundaries between the dates. date_part(part, date) Get the subfield (equivalent to extract ). date_sub(part, startdate, enddate) The number of complete partitions between the dates. date_trunc(part, date) Truncate...umber of partition boundaries between the dates. Alias of date_diff . datepart(part, date) Get the subfield (equivalent to extract ). Alias of date_part . datesub(part, startdate, enddate) The number of complete partitions between the dates. Alias of da...trunc(part, date) Truncate to specified precision . Alias of date_trunc . dayname(date) The (English) name of the weekday. extract(part from date) Get subfield from a date. greatest(date, date) The later of two dates. isfinite(date) Returns true if the... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Interval Functions – DuckDB 8844
- 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
...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...a year 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. Ex... - https://man.mtool.work/duckdb/1.3/sql/functions/interval.html
- List Functions – DuckDB 8473
- 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
...n / SQL / Functions Copy Markdown List Functions Name Description list[index] Bracket notation serves as an alias for list_extract . list[begin:end] Bracket notation with colon is an alias for list_slice . list[begin:end:step] list_slice in bracket nota...ist1, list2) Computes the negative dot product of two same-sized lists of numbers. Equivalent to - list_dot_product . list_extract(list, index) Extract the index th (1-based) value from the list. list_filter(list, lambda) Constructs a list from those el...ed by the index_list . list_slice(list, begin, end, step) list_slice with added step feature. list_slice(list, begin, end) Extract a sublist using slice conventions. Negative values are accepted. See slicing . list_sort(list) Sorts the elements of the l... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Text Functions – DuckDB 8361
- 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
...is section describes functions and operators for examining and manipulating STRING values . Name Description string[index] Extracts a single character using a (1-based) index. string[begin:end] Extracts a string using slice conventions similar to Python..., lists, 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)... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
DuckDB 1.3 Documentation / man.mtool.work