Re: [SQL] query an array... - Mailing list pgsql-sql

From Jason Earl
Subject Re: [SQL] query an array...
Date
Msg-id 199905191328.HAA29087@earlj.nesusa.com
Whole thread Raw
In response to query an array...  (Heiko Wilms <wilms@stud.fh-hannover.de>)
List pgsql-sql
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







pgsql-sql by date:

Previous
From: Jason Earl
Date:
Subject: Re: [SQL] Why wont this update work?
Next
From: secret
Date:
Subject: Re: [SQL] Oddities with NULL and GROUP BY