Arrays Question

Поиск
Список
Период
Сортировка
Искать

Arrays Question

От:
Achilleus Mantzios <rnd@gatewaynet.com>
Дата:
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

FAQ