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