Arrays Question

From: Achilleus Mantzios <rnd(at)gatewaynet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Arrays Question
Date: 2002-01-25 14:56:22
Message-ID: 02012516562200.29211@pc216
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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(at)dynacomtm(dot)com
rnd(at)gatewaynet(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-01-25 15:12:51 Re: persistent portals/cursors (between transactions)
Previous Message Florian Wunderlich 2002-01-25 13:01:45 Re: persistent portals/cursors (between transactions)

Browse pgsql-sql by date

  From Date Subject
Next Message SHELTON,MICHAEL (Non-HP-Boise,ex1) 2002-01-25 15:12:01 Re: linking from SQL Server
Previous Message Bhuvan A 2002-01-25 10:58:19 Good tutorial on plperl.