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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: rod(at)iol(dot)ie
Cc: Ozz Nixon <ozznixon(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Inserting multiple values, was Re: solaris tarballs and pl/java
Date: 2010-04-16 01:34:10
Message-ID: g2rdcc563d11004151834oc2662616hdd69c4ce4d6c0dec@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 15, 2010 at 1:49 PM, Raymond O'Donnell <rod(at)iol(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2010-04-16 01:59:54 Re: General Question about database -- redirection
Previous Message Jorge Godoy 2010-04-16 00:49:33 Re: General Question about database -- redirection