SQL
Array Type
An `ARRAY` column stores fixed-sized arrays. All fields in the column must have the same length and the same underlying type. Arrays are typically used to store arrays of numbers, but can contain any uniform data type, including `ARRAY`, [`LIST`](#docs:sql:data_types:list) and [`STRUCT`](#docs:sql:data_types:struct) types.  
Arrays can be used to store vectors such as [word embeddings](https://en.wikipedia.org/wiki/Word_embedding) or image embeddings.  
To store variable-length lists, use the [`LIST` type](#docs:sql:data_types:list). See the [data types overview](#docs:sql:data_types:overview) for a comparison between nested data types.  
> The `ARRAY` type in PostgreSQL allows variable-length fields. DuckDB's `ARRAY` type is fixed-length.