* Richard Huxton:
>> 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
Hello
se own unpack sql function
http://www.pgsql.cz/index.php/PostgreSQL_SQL_Tricks#Array_to_table
Regards
Pavel Stehule
2008/7/17 Florian Weimer <[EMAIL PROTECTED]>:
> 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 t
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 a
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 nowada
