Re: Re: [HACKERS] extra syntax on INSERT

From: Tod McQuillin <devin(at)spamcop(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Limin Liu <limin(at)pumpkinnet(dot)com>, <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: [HACKERS] extra syntax on INSERT
Date: 2001-06-02 02:24:34
Message-ID: Pine.GSO.4.33.0106012123000.29707-100000@sysadmin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, 31 May 2001, Tom Lane wrote:

> Limin Liu <limin(at)pumpkinnet(dot)com> writes:
> > I just realized that INSERT allows us to have more syntax than the
> > manual said. I wonder if we want to elimiate it or keep it with more
> > documentation on the INSERT statment?
>
> This will likely go away when we get around to upgrading INSERT to the
> full SQL spec --- certainly I'd feel no compunction about removing any
> non-SQL syntax that happens to be supported now, if it gets in the way
> of spec compliance.

Are you talking about allowing multiple rows in one insert, like this?

INSERT into foo VALUES ((1, 2, 3), (4, 5, 6), (7, 8, 9))

That would be a nice feature to have, and I think it's consistent with
SQL-92.
--
Tod McQuillin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gerald Gutierrez 2001-06-02 03:24:32 Turning on/off the logfile
Previous Message Gerald Gutierrez 2001-06-02 01:21:25 PostgreSQL Replication Server?

Browse pgsql-hackers by date

  From Date Subject
Next Message Kaare Rasmussen 2001-06-02 07:45:44 Re: Re: Interesting Atricle
Previous Message Bruce Momjian 2001-06-02 01:18:28 Re: Re: Interesting Atricle