On Thu, Apr 15, 2010 at 1:49 PM, Raymond O'Donnell <rod@iol.ie> 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||',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
Remove the | symbols and it should