Re: Re: [HACKERS] extra syntax on INSERT

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