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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mani <kmani(dot)k78(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: TODO Item - "Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)"
Date: 2006-02-13 07:00:19
Message-ID: 19656.1139814019@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

mani <kmani(dot)k78(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Q Beukes 2006-02-13 08:06:51 Re: pg_hba.conf alternative
Previous Message mani 2006-02-13 04:49:29 TODO Item - "Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)"