array to rows of it's elements?

From: "Celia McInnis" <celia(at)drmath(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: array to rows of it's elements?
Date: 2005-07-06 14:37:10
Message-ID: 20050706142817.M73402@drmath.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-07-06 14:46:57 Re: Rules and transactions
Previous Message Andreas Kretschmer 2005-07-06 12:13:01 Re: [despammed] Rules and transactions