From: Harald Fuchs <use_reply_to@protecting.net>
To: pgsql-performance@postgresql.org
Subject: Re: COPY vs INSERT
Date: 06 May 2005 11:27:43 +0200
Message-ID: <puu0lg4sc0.fsf@srv.protecting.net> (raw)
References: <20050506065129.GL88920@decibel.org>
<Pine.LNX.4.44.0505060927520.7072-100000@zigo.dhs.org>
In article <Pine.LNX.4.44.0505060927520.7072-100000@zigo.dhs.org>,
Dennis Bjorklund <db@zigo.dhs.org> writes:
> On Fri, 6 May 2005, Jim C. Nasby wrote:
>> Has thought been given to supporting inserting multiple rows in a single
>> insert? DB2 supported:
>>
>> INSERT INTO table VALUES(
>> (1,2,3),
>> (4,5,6),
>> (7,8,9)
>> );
>>
>> I'm not sure how standard that is or if other databases support it.
> The sql standard include this, except that you can not have the outer ().
> So it should be
> INSERT INTO table VALUES
> (1,2,3),
> (4,5,6),
> (7,8,9);
Since MySQL has benn supporting this idiom for ages, it can't be
standard ;-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: use_reply_to@protecting.net
Subject: Re: COPY vs INSERT
In-Reply-To: <puu0lg4sc0.fsf@srv.protecting.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox