Results of 1 - 3 of about 3 for heron (0.001 sec.)
- List Type 11868
- 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
...aggregate function. List of integers: SELECT [1, 2, 3]; List of strings with a NULL value: SELECT ['duck', 'goose', NULL, 'heron']; List of lists with NULL values: SELECT [['duck', 'goose', 'heron'], NULL, ['frog', 'toad'], []]; Create a list with the... - https://man.mtool.work/duckdb/2.0/sql/data_types/list.html
- Struct Data Type 8482
- 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.
..., 'z': 3} AS s; Create a struct of strings with a NULL value: SELECT {'yes': 'duck', 'maybe': 'goose', 'huh': NULL, 'no': 'heron'} AS s; Create a struct with a different type for each key: SELECT {'key1': 'string', 'key2': 1, 'key3': 12.345} AS s; Cre...ate a struct of structs with NULL values: SELECT { 'birds': {'yes': 'duck', 'maybe': 'goose', 'huh': NULL, 'no': 'heron'}, 'aliens': NULL, 'amphibians': {'yes': 'frog', 'maybe': 'salamander', 'huh': 'dragon', 'no': 'toad'} } AS s; New As of D... - https://man.mtool.work/duckdb/2.0/sql/data_types/struct.html
- Data Types 7515
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...arily nested to any depth, so long as the type rules are observed. Struct with LIST s: SELECT {'birds': ['duck', 'goose', 'heron'], 'aliens': NULL, 'amphibians': ['frog', 'toad']}; Struct with list of MAP s: SELECT {'test': [MAP([1, 5], [42.1, 45]), M... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work