Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group