dbTalk Databases Forums  

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2649: wish: provide multi-row INSERT with VALUES in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Maciej Pilichowski
 
Posts: n/a

Default [BUGS] BUG #2649: wish: provide multi-row INSERT with VALUES - 09-24-2006 , 04:16 PM







The following bug has been logged online:

Bug reference: 2649
Logged by: Maciej Pilichowski
Email address: macias (AT) mat (DOT) 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

Reply With Quote
  #2  
Old   
Harald Armin Massa
 
Posts: n/a

Default Re: [BUGS] BUG #2649: wish: provide multi-row INSERT with VALUES - 09-25-2006 , 02:03 AM






------=_Part_25165_30161792.1159167658881
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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 (AT) mat (DOT) uni.torun.pl> wrote:
Quote:

The following bug has been logged online:

Bug reference: 2649
Logged by: Maciej Pilichowski
Email address: macias (AT) mat (DOT) 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.l...hread/285b9ad=
eec188fb2

------=_Part_25165_30161792.1159167658881
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Maciej,<br><br>this feature is scheduled for PostgreSQL 8.2 and allready in=
the release notes of that release, coming most likely eoty.<br><br>Harald<=
br><br><div><span class=3D"gmail_quote">On 9/24/06, <b class=3D"gmail_sende=
rname">
Maciej Pilichowski</b> &lt;<a href=3D"mailto:macias (AT) mat (DOT) uni.torun.pl">macia=
s (AT) mat (DOT) uni.torun.pl</a>&gt; wrote:</span><blockquote class=3D"gmail_quote" s=
tyle=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8e=
x; padding-left: 1ex;">
<br>The following bug has been logged online:<br><br>Bug reference:&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;2649<br>Logged by:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Maciej Pilichowski<br>Email address:&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=3D"mailto:macias (AT) mat (DOT) uni.torun.pl">maci=
as (AT) mat (DOT) uni.torun.pl</a><br>PostgreSQL version:=20
8.0.3<br>Operating system:&nbsp;&nbsp; opensuse 10.0<br>Description:&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;wish: provide multi-row INSERT wit=
h VALUES<br>Details:<br><br>There is:<br>INSERT ...<br>VALUES (...);<br><br=
Quote:
however it would be a nice extension to have:
br>INSERT ...<br>VALUES<br>(...), -- the first row with values<br>(...), -=
- the 2nd<br>(...); -- the 3rd, etc.<br><br>---------------------------(end=
of broadcast)---------------------------<br>TIP 5: don't forget to increas=
e your free space map settings
<br></blockquote></div><br><br clear=3D"all"><br>-- <br>GHUM Harald Massa<b=
r>persuadere et programmare<br>Harald Armin Massa<br>Reinsburgstra=DFe 202b=
<br>70197 Stuttgart<br>0173/9409607<br>-<br>Python: the only language with =
more web frameworks than keywords.
<br> -- Harald A. Massa, December 2005 <br><a href=3D"http://groups.google.=
de/group/comp.lang.python/browse_thread/thread/285b9adeec188fb2">http://gro=
ups.google.de/group/comp.lang.python/browse_thread/thread/285b9adeec188fb2
</a>

------=_Part_25165_30161792.1159167658881--


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.