Results of 1 - 7 of about 7 for Bracket (0.004 sec.)
- Struct Functions – DuckDB 12286
- 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
...s 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...as an alias for struct_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 s...truct[idx] Description Bracket notation that serves as an alias for struct_extract from unnamed STRUCT s (tuples), using an index (1-based). Example (row... - https://man.mtool.work/duckdb/1.3/sql/functions/struct.html
- List Functions – DuckDB 10923
- 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 Format Pivot Sitemap Live Demo Documentation / 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 . li...st[begin:end:step] list_slice in bracket notation with an added step feature. array_pop_back(list) Returns the list without the last element. array_pop_front(list)...special function that alters the cardinality of the result. See the unnest page for more details. list[index] Description Bracket notation serves as an alias for list_extract . Example [4, 5, 6][3] Result 6 Alias list_extract list[begin:end] Descriptio... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Map Type – DuckDB 9342
- 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
...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=...( 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 ha...e Map Functions . 関連キーワード values keys nested type types list comparison also using extract ordered need single Keys bracket Maps entries contained used compare rules member Functions Documentation Types 関連するページ Data Types Map Functions Str... - https://man.mtool.work/duckdb/1.3/sql/data_types/map.html
- Pattern Matching – DuckDB 8888
- 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
...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/1.3/sql/functions/pattern_matching.html
- Reading Multiple Files – DuckDB 7979
- 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
...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/1.3/data/multiple_files/overview.html
- Struct Data Type – DuckDB 7306
- 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
...' : 3 }, d : = 4 ) AS s ; 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...e, 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 f... - https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html
- List Type – DuckDB 6852
- 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
...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...ER [], 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/1.3/sql/data_types/list.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work