Re: Multi-row insert using a Function

On 2010-11-24, Michael Rowan <mike(dot)rowan(at)internode(dot)on(dot)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 integer columns. Another function inserts a single row correctly, but I do not see how to arrange the data for the multiple row function. I assume it needs to be in an array, but I cannot find an example in the docs, and am darned if I can 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