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

2010-04-15 Thread Scott Marlowe
On Thu, Apr 15, 2010 at 1:49 PM, Raymond O'Donnell wrote: > 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|

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

2010-04-15 Thread Raymond O'Donnell
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 i