From: Jim C. Nasby <decibel@decibel.org>
To: Dennis Bjorklund <db@zigo.dhs.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: David Roussel <pgsql-performance@diroussel.xsmail.com>
Cc: Mischa Sandberg <mischa.sandberg@telus.net>
Cc: pgsql-perform <pgsql-performance@postgresql.org>
Subject: Re: COPY vs INSERT
Date: Sun, 8 May 2005 12:12:32 -0500
Message-ID: <20050508171232.GD88920@decibel.org> (raw)
In-Reply-To: <Pine.LNX.4.44.0505060927520.7072-100000@zigo.dhs.org>
References: <20050506065129.GL88920@decibel.org>
<Pine.LNX.4.44.0505060927520.7072-100000@zigo.dhs.org>
On Fri, May 06, 2005 at 09:30:46AM +0200, Dennis Bjorklund wrote:
> 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);
>
> Do DB2 demand these extra ()?
My recollection is that it does, but it's been a few years...
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
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: decibel@decibel.org, db@zigo.dhs.org, tgl@sss.pgh.pa.us, chriskl@familyhealth.com.au, pgsql-performance@diroussel.xsmail.com, mischa.sandberg@telus.net
Subject: Re: COPY vs INSERT
In-Reply-To: <20050508171232.GD88920@decibel.org>
* 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