Arrays Question
От | Achilleus Mantzios |
---|---|
Тема | Arrays Question |
Дата | |
Msg-id | 02012516562200.29211@pc216 обсуждение исходный текст |
Ответы |
Re: Arrays Question
|
Список | pgsql-sql |
Hi Is it possible to have subarrays from an array constant?? Is it possible to have indices on arrays?? For the first here it is whats on 7.1.2: dynacom=# select '{1,2,3}'::_int4 ; ?column? ---------- {1,2,3} (1 row) dynacom=# dynacom=# select '{1,2,3}[1:2]'::_int4 ; ?column? ---------- {1,2,3} (1 row) dynacom=# What would someone expect is the select to return {1,2}. Any one has a clue??? If postgresql had this feature along with the indexing on arrays, that would make it (not that it is not allready!) the perfect candidate for tree manipulation. Thanx in advance -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel: +30-10-8981112 fax: +30-10-8981877 email: it@dynacomtm.com rnd@gatewaynet.com
В списке pgsql-sql по дате отправления: