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

Started by maniabout 20 years ago2 messageshackers
Jump to latest
#1mani
kmani.k78@gmail.com

I would like to work on TODO item - "Allow INSERT INTO tab (col1, ..) VALUES
(val1, ..), (val2, ..)"
Any suggestion / comments ?

Thanks
K. Manikandan

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: mani (#1)
Re: TODO Item - "Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)"

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