Results of 1 - 7 of about 7 for bracket (0.001 sec.)
- Struct Functions 11996
- 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
.... 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 al...ruct_extract from named STRUCT s. | | Example | ({'i': 3, 's': 'string'}).i | | Result | 3 | struct[entry] | Description | Bracket notation that serves as an alias for struct_extract from named STRUCT s. | | Example | ({'i': 3, 's': 'string'})['i'] | |...Result | 3 | struct[idx] | Description | Bracket notation that serves as an alias for struct_extract from TUPLE s, using an index (1-based). | | Example | (row(42, 84))[1]... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Pattern Matching 10469
- There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE ex
...ldcard to match any single character and the asterisk ( * ) 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 t...he brackets. An exclamation mark ( ! ) may be used inside the first bracket to search for a character that is not contained within th...e brackets. To learn more, visit the “glob (programming)” Wikipedia page . GLOB The GLOB operator returns true or false if the strin... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Map Type 9869
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
...ave a different type. See the data types overview for a comparison between nested data types. To construct a MAP , use the bracket syntax preceded by the MAP keyword. Creating Maps A map with VARCHAR keys and INTEGER values. This returns {key1=10, key2=...E tbl (col MAP(INTEGER, DOUBLE)); Retrieving from Maps MAP values can be retrieved using the map_extract_value function or bracket notation: SELECT MAP {'key1': 5, 'key2': 43}['key1']; 5 If the key has the wrong type, an error is thrown. If it has the c... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- Reading Multiple Files 8942
- DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different sch
...ches any number of subdirectories (including none) ? Matches any single character [abc] Matches one character given in the bracket [a-z] Matches one character from the range given in the bracket Note that the ? wildcard in globs is not supported for rea... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- Struct Data Type 8942
- Conceptually, a STRUCT column contains an ordered list of columns called “entries”. The entries are referenced by name using strings. This document refers to those entry names as keys. Each row in the STRUCT column must have the same keys.
...t updating existing ones. Retrieving from Structs Retrieving a value from a struct can be accomplished using dot notation, bracket notation, or through struct functions like struct_extract . Use dot notation to retrieve the value at a key's location. In...ains a space, simply wrap it in double quotes ( " ). SELECT a."x space" FROM (SELECT {'x space': 1, 'y': 2, 'z': 3} AS a); Bracket notation may also be used. Note that this uses single quotes ( ' ) since the goal is to specify a certain string key and o...nly constant expressions may be used inside the brackets (no expressions): SELECT a['x space'] FROM (SELECT {'x space': 1, 'y': 2, 'z': 3} AS a); The struct_extract function is a... - https://man.mtool.work/duckdb/2.0/sql/data_types/struct.html
- List Type 7124
- A LIST column encodes lists of values. Fields in the column can have values with different lengths, but they must all have the same underlying type. LIST s are typically used to store arrays of numbers, but can contain any uniform data type
...uckDB uses the ARRAY type . Creating Lists Lists can be created using the list_value(expr, ...) function or the equivalent bracket notation [expr, ...] . The expressions can be constants or arbitrary expressions. To create a list from a table column, us...EGER[], varchar_list VARCHAR[]); Retrieving from Lists Retrieving one or more values from a list can be accomplished using brackets and slicing notation, or through list functions like list_extract . Multiple equivalent functions are provided as aliases... - https://man.mtool.work/duckdb/2.0/sql/data_types/list.html
- List Functions 6216
- 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 <->
...< 0 and -begin > length , begin is clamped to the beginning of the list When begin > length , the result is an empty list Bracket Notation: When begin is omitted, it defaults to the beginning of the list end Is the index of the last element to be inclu...unted from the end of the list When end > length , end is clamped to length When end < begin , the result is an empty list Bracket Notation: When end is omitted, it defaults to the end of the list. When end is omitted and a step is provided, end must be... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work