Thread: query an array...

query an array...

From
Heiko Wilms
Date:
> Hi,
>
> I stucked upon the following situation:
> create table test (
>     n    int[]   );
>
> insert into test values (
>
>     '{1,2,3,4}'
>
> );
>
> now I need a query that returns all four numbers in different variables,i.e.
>
> an array like n[1],...,n[4]
>
> I tried queries like
>
>     select test.n from test which returns {1,2,3,4}
>
> or
>
>     select test.n[i] from test,  where i is 1,2,3 or 4 which each returns 1,2,...
>
> What I'm looking for is a query that returns four rows with one number in each
>
> result index. Can anyone help?
>

--
H. Wilms

Homepage schering.si2.uni-hannover.de/hugo
email    wilms@stud.fh-hannover.de





Re: [SQL] query an array...

From
Jason Earl
Date:
Try:

SELECT test.n[1], test.n[2], test.n[3], test.n[4] from test;

It should get you what you need.

Or you could make it a little more clear with something like:

SELECT       test.n[1] as one, test.n[2] as two, test.n[3] as three,      test.n[4] as four      FROM test;

As that would give you more descriptive column names (which is a
useful thing in PHP).
  > Hi,  >  > I stucked upon the following situation:  > create table test (  >     n    int[]   );  >  > insert into
testvalues (  >  >     '{1,2,3,4}'  >  > );  >  > now I need a query that returns all four numbers in different  >
variables,i.e. >  > an array like n[1],...,n[4]  >  > I tried queries like  >  >     select test.n from test which
returns{1,2,3,4}  >  > or  >  >     select test.n[i] from test, where i is 1,2,3 or 4 which each  >     returns 1,2,...
>  > What I'm looking for is a query that returns four rows with one  > number in each  >  > result index. Can anyone
help? >
 
  --  H. Wilms
  Homepage schering.si2.uni-hannover.de/hugo  email    wilms@stud.fh-hannover.de