Re: [Sqlalchemy-tickets] [sqlalchemy] #2785: Array index in postgres ARRAy

[sqlalchemy <mi...@zz...>]

#2785: Array index in postgres ARRAy
------------------------------+------------------------------------
      Reporter:  aterentev    |      Owner:  zzzeek
          Type:  enhancement  |     Status:  new
      Priority:  medium       |  Milestone:  0.8.xx
     Component:  postgres     |   Severity:  no triage selected yet
    Resolution:               |   Keywords:
Progress State:  in queue     |
------------------------------+------------------------------------

Comment (by zzzeek):

 I think we'd want to make the zero index adjustment against literal Python
 values only, not in SQL.   like if someone said
 `table.c.somecolumn[someother_table.c.column]`, assume
 `someother_table.c.column` is one-based.   Though I think there's lots of
 potentially untenable situations here if someone really makes heavy use of
 hybrid behavior in conjunction with array indexing, ultimately in such a
 situation they may have to build their own comparators to work things out
 as needed.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2785#comment:2>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python