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.
Michael Rowan
mike(dot)rowan(at)internode(dot)on(dot)net