Inserting multiple values, was Re: solaris tarballs and pl/java

On 15/04/2010 20:44, Ozz Nixon wrote:
> Would this syntax work in PostgreSQL?
>
> |INSERT INTO MyTable (FirstCol, SecondCol)
> VALUES ('First',1),
> || ('||Second||',2),|
> | ('||Third||',3),|
> | ('||Fourth||',4),|
> | ('||Fifth||',5)||
> |
> Inserting 5 rows in a single Insert? (I am trying to implement this
> solution across many different backends) works on SQL Server 2008, need
> to make sure it will work on many others.

http://www.postgresql.org/docs/8.4/static/sql-insert.html


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie