Re: Re: [HACKERS] extra syntax on INSERT

Поиск
Список
Период
Сортировка
От Tod McQuillin
Тема Re: Re: [HACKERS] extra syntax on INSERT
Дата
Msg-id Pine.GSO.4.33.0106012123000.29707-100000@sysadmin
обсуждение исходный текст
Ответ на Re: [HACKERS] extra syntax on INSERT  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Thu, 31 May 2001, Tom Lane wrote:

> Limin Liu <limin@pumpkinnet.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




В списке pgsql-general по дате отправления: