| 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: | Whole Thread | Raw Message | 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
| 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) |
| 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. |