Обсуждение: 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