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