Re: COPY vs INSERT - Mailing list 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