Array with a lower bound>1, PostgreSQL 8.3.6
Thomas Jacob <[email protected]>
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Message-ID | <[email protected]> |
Hello List,
I was wondering if there are any plans to properly support arrays with a
lower bound greater than one:
CREATE TABLE test ( a TEXT[]);
INSERT INTO test values ('[100:100]={}');
SELECT * FROM test;
a
---------------
[100:100]={1}
SELECT a[100],a[10] IS NULL FROM test;
Intuitively I'd expect result columns to behave in a similar
way, with the result array looking like:
[None for x in xrange(99) ].append(1)
while currently [1] is returned.
Regards,
Thomas