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

• Re: [HACKERS] extra syntax on INSERT at 2001-06-01 00:58:34 from Tom Lane

pgsql-hackers by date

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

pgsql-general by date

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