BUG #2649: wish: provide multi-row INSERT with VALUES

Maciej Pilichowski wrote:

The following bug has been logged online:

Bug reference: 2649
Logged by: Maciej Pilichowski
Email address: macias@mat.uni.torun.pl
PostgreSQL version: 8.0.3
Operating system: opensuse 10.0
Description: wish: provide multi-row INSERT with VALUES
Details:

There is:
INSERT ...
VALUES (...);

however it would be a nice extension to have:
INSERT ...
VALUES
(...), -- the first row with values
(...), -- the 2nd
(...); -- the 3rd, etc.

This will be supported in PostgreSQL 8.2.

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Maciej,

this feature is scheduled for PostgreSQL 8.2 and allready in the release
notes of that release, coming most likely eoty.

Harald

On 9/24/06, Maciej Pilichowski <macias@mat.uni.torun.pl> wrote:

The following bug has been logged online:

Bug reference: 2649
Logged by: Maciej Pilichowski
Email address: macias@mat.uni.torun.pl
PostgreSQL version: 8.0.3
Operating system: opensuse 10.0
Description: wish: provide multi-row INSERT with VALUES
Details:

There is:
INSERT ...
VALUES (...);

however it would be a nice extension to have:
INSERT ...
VALUES
(...), -- the first row with values
(...), -- the 2nd
(...); -- the 3rd, etc.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
-- Harald A. Massa, December 2005
http://groups.google.de/group/comp.lang.python/browse_thread/thread/285b9adeec188fb2