Re: Multi-row insert using a Function

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