Обсуждение: BUG #2649: wish: provide multi-row INSERT with VALUES

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.

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
>



--=20
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstra=DFe 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/285b9ad=
eec188fb2