Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

Next:From: Kaare RasmussenDate: 2001-06-02 07:45:44
Subject: Re: Re: Interesting Atricle
Previous:From: Bruce MomjianDate: 2001-06-02 01:18:28
Subject: Re: Re: Interesting Atricle

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group