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

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. +

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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.l...5b9adeec188fb2