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

["Raymond O'Donnell" <rod@xxxxxx>]

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@xxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general