Re: Generating table rows from arrays

Florian Weimer wrote:
> Is there a convenient way to turn an array into table rows?  For
> example, I've got an array like {1, 2, 3} and would like to insert
> rows:
> 
>   ('aaa', 1)
>   ('aaa', 2)
>   ('aaa', 3)
> 
> The first row is constant.  I could write a loop with PL/pgsql, I
> guess, but I wonder if there are better options nowadays.

The smallest function I've seen is Merlin Moncure's here:

http://people.planetpostgresql.org/merlin/index.php?/archives/4-fun-with-arrays.html


--   Richard Huxton  Archonet Ltd