Data Import
Indexing
> **Warning.  ** Following [PostgreSQL's conventions](#docs:sql:dialect:postgresql_compatibility), DuckDB uses 1-based indexing for its [`ARRAY`](#docs:sql:data_types:array) and [`LIST`](#docs:sql:data_types:list) data types but [0-based indexing for the JSON data type](https://www.postgresql.org/docs/17/functions-json.html#FUNCTIONS-JSON-PROCESSING).