From: | Jason Aten <jaten(at)CS(dot)UCLA(dot)EDU> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Are arrays broken in 7.0.3? |
Date: | 2000-12-18 22:15:30 |
Message-ID: | Pine.SOL.4.10.10012181412031.27164-100000@panther.cs.ucla.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom:
Ah-hah! thanks!
Is there some way to find the dimensions of an array once it
has been inserted into a table? (or to just ask for it all, like saying
[:] in matlab? )
-Jason
On Mon, 18 Dec 2000, Tom Lane wrote:
> Jason Aten <jaten(at)CS(dot)UCLA(dot)EDU> writes:
> > testdb=# select f[2][1:5] from arr; (ask row back, get two!)
>
> This is implicitly an array slice operation, so it's the same as
> select f[1:2][1:5] from arr;
> If you want just the one row you need to write
> select f[2:2][1:5] from arr;
>
> The behavior of the cases with too few subscripts does seem pretty
> unhelpful --- seems like either raising an error or returning a
> slice would make more sense than returning NULL. But that's how
> the code is set up at the moment.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-12-18 22:20:00 | Re: Are arrays broken in 7.0.3? |
Previous Message | Tom Lane | 2000-12-18 22:08:04 | Re: Are arrays broken in 7.0.3? |