Обсуждение: TODO Item - "Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)"

Поиск
Список
Период
Сортировка

TODO Item - "Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)"

От
mani
Дата:
I would like to work on TODO item - "Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)"<br />Any
suggestion/ comments ?<br /><br />Thanks<br />K. Manikandan<br /> 

Re: TODO Item - "Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)"

От
Tom Lane
Дата:
mani <kmani.k78@gmail.com> writes:
> I would like to work on TODO item - "Allow INSERT INTO tab (col1, ..) VALUE=
> S
> (val1, ..), (val2, ..)"
> Any suggestion / comments ?

If you look at the SQL spec, INSERT/VALUES is actually just a special
case --- VALUES is supposed to be a table construct that can be used in
SELECT, etc, just as if it were a table source.  It'd be nice to support
the general case.
        regards, tom lane