SQL
List Type
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, including other `LIST`s and `STRUCT`s.  
`LIST`s are similar to PostgreSQL's `ARRAY` type. DuckDB uses the `LIST` terminology, but some [`array_` functions](#docs:sql:functions:list) are provided for PostgreSQL compatibility.  
See the [data types overview](#docs:sql:data_types:overview) for a comparison between nested data types.  
> For storing fixed-length lists, DuckDB uses the [`ARRAY` type](#docs:sql:data_types:array).