Results of 1 - 2 of about 2 for subscripts (0.001 sec.)
- Unnesting 11228
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...Element Index Unnesting a value of the LIST -type yields only the element values. To also keep track of their indices (the subscripts), you can use the built-in macro generate_subscripts() . The generate_subscripts macro takes a value of the LIST -type as...List Entry Positions To keep track of each entry's position within the original list, unnest may be combined with generate_subscripts : SELECT unnest(l) AS x, generate_subscripts(l, 1) AS index FROM (VALUES ([1, 2, 3]), ([4, 5])) tbl(l); x index 1 1 2 2 3... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- List Functions 7485
- 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 <->
...CT generate_series(2, 5); [2, 3, 4, 5] generate_series(start, stop, step) SELECT generate_series(2, 5, 3); [2, 5] generate_subscripts(arr, dim) The generate_subscripts(arr, dim) function generates indexes along the dim th dimension of array arr . SELECT ge...nerate_subscripts([4, 5, 6], 1) AS i; i 1 2 3 Date Ranges Date ranges are also supported for TIMESTAMP and TIMESTAMP WITH TIME ZONE values.... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work