Re: [SQL] query an array...

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