array to rows of it's elements? - Mailing list pgsql-novice

From Celia McInnis
Subject array to rows of it's elements?
Date
Msg-id 20050706142817.M73402@drmath.ca
Whole thread Raw
Responses Re: array to rows of it's elements?  ("Celia McInnis" <celia@drmath.ca>)
List pgsql-novice
Is there a function which will return the elements of an array as rows of
entries? What I'd like in the 1 dimensional array case is something like:

   select array-to-rows(ARRAY[1,2,3]);

giving

   1
   2
   3
(3 rows)

Thanks,
Celia McInnis

pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] Rules and transactions
Next
From: Tom Lane
Date:
Subject: Re: Rules and transactions