Results of 1 - 1 of about 1 for unnested (0.001 sec.)
- Unnesting 9414
- 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
...The member key becomes the column name, and the member value becomes a column value. Values of a STRUCT -type may also be unnested using dot-star ( ⟨struct⟩.* ) shorthand syntax , but the unnest() function offers some additional functionality. For a TUP...member, prefixed by element . The dot-star ( ⟨struct⟩.* ) shorthand syntax is not available for tuples: tuples can only be unnested using the unnest() function. Calling unnest() The LIST or STRUCT value that is to be unnested is always passed as the firs...LIST -typed values, it is useful to distinguish between the 'input' row that provided the LIST -typed value that is to be unnested, and the 'output' row(s) created by the unnesting operation. An individual invocation to unnest() on the LIST -typed value... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work