Multi-row insert using a Function - Mailing list pgsql-novice

From Michael Rowan
Subject Multi-row insert using a Function
Date
Msg-id D2E3658A-9E47-42C8-80DB-FE72DC0824EE@internode.on.net
Whole thread Raw
List pgsql-novice
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.


Michael Rowan
mike.rowan@internode.on.net





pgsql-novice by date:

Previous
From: "Rob Richardson"
Date:
Subject: Re: Why won't this function loop?
Next
From: bakkiya
Date:
Subject: Re: Could not open relation with OID (table partitioning issue?)