On 2010-11-24, Michael Rowan <mike.rowan@internode.on.net> wrote:
> Very new to Postgres and functions.
>
> Using PostgreSQL 9 and pl/pgsql I wish to use a function to insert several rows into a table. The table has text and
integercolumns. Another function inserts a single row correctly, but I do not see how to arrange the data for the
multiplerow function. I assume it needs to be in an array, but I cannot find an example in the docs, and am darned if
Ican send it something acceptable.
>
> Any example would help. Thanks.
what are you trying to do?
possible solutions include one multi-row insert, several single-row inserts, or a
single single-row insert repeated multiple times using a loop.
--
⚂⚃ 100% natural