Array index in postgres ARRAy
When I work with SQLAlchemy and PostgreSQL I find interesting and unobvious nuance:
When using item of array in filter or order_by there are need to use indexes starts from 1 (there are no index 0 in pestgres ARRAY) But, for getting value or values and use it there are need to use indexes starts from zero.
May be would be better change logic of getitem method of sqlalchemy.dialects.postgresql.ARRAY for use one standart of indexes in all situations.
Regards, Alexey Terentev