✳flâneur — a map of the web's best reading

Nested Functions - DuckDB

duckdb.org · 9 words · saved by 1 readers

This section describes functions and operators for examining and manipulating nested values. There are five nested data types: ARRAY, LIST, MAP, STRUCT, and UNION. In the descriptions, l is the three element list [4, 5, 6]. The following operators are supported for lists: Python-style list comprehension can be used to compute expressions over elements in a list. For example: The functions range and generate_series create a list of values in the range between start and stop. The start parameter is inclusive. For the range function, the stop parameter is exclusive, while for generate_series, it is inclusive. Based on the number of arguments, the following variants exist: The default value of start is 0 and the default value of step is 1. Date ranges are also supported: The function list_slice can be used to extract a sublist from a list. The following variants exist: list begin end step (optional) The function list_aggregate allows the execution of arbitrary existing aggregate functions

Redirecting… Redirecting… Click here if you are not redirected.

Explore this link on the map →

related reading