Re: COPY vs INSERT

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, David Roussel <pgsql-performance(at)diroussel(dot)xsmail(dot)com>, Mischa Sandberg <mischa(dot)sandberg(at)telus(dot)net>, pgsql-perform <pgsql-performance(at)postgresql(dot)org>
Subject: Re: COPY vs INSERT
Date: 2005-05-06 07:30:46
Message-ID: Pine.LNX.4.44.0505060927520.7072-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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);

Do DB2 demand these extra ()?

--
/Dennis Björklund

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jona 2005-05-06 07:34:34 Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9
Previous Message Jona 2005-05-06 07:28:06 Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9