Skip to content

Commit 510aad3

Browse files
committed
Done:
< o Allow INSERT/UPDATE ... RETURNING new.col or old.col < < This is useful for returning the auto-generated key for an INSERT. < One complication is how to handle rules that run as part of < the insert. < http://archives.postgresql.org/pgsql-patches/2005-07/msg00568.php > o -Allow INSERT/UPDATE ... RETURNING new.col or old.col
1 parent aeb056f commit 510aad3

File tree

2 files changed

+8
-17
lines changed

2 files changed

+8
-17
lines changed

doc/TODO

Lines changed: 2 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer: Bruce Momjian (bruce@momjian.us)
5-
Last updated: Fri Aug 11 16:17:22 EDT 2006
5+
Last updated: Fri Aug 11 23:50:26 EDT 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -653,12 +653,7 @@ SQL Commands
653653

654654
o Allow INSERT/UPDATE of the system-generated oid value for a row
655655
o -Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)
656-
o Allow INSERT/UPDATE ... RETURNING new.col or old.col
657-
658-
This is useful for returning the auto-generated key for an INSERT.
659-
One complication is how to handle rules that run as part of
660-
the insert.
661-
http://archives.postgresql.org/pgsql-patches/2005-07/msg00568.php
656+
o -Allow INSERT/UPDATE ... RETURNING new.col or old.col
662657
o In rules, allow VALUES() to contain a mixture of 'old' and 'new'
663658
references
664659

doc/src/FAQ/TODO.html

Lines changed: 6 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF">
99
<h1><a name="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<a href="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated: Fri Aug 11 16:17:22 EDT 2006
11+
Last updated: Fri Aug 11 23:50:26 EDT 2006
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -591,15 +591,11 @@ <h1><a name="section_8">SQL Commands</a></h1>
591591
<ul>
592592
<li>Allow INSERT/UPDATE of the system-generated oid value for a row
593593
</li><li>-<em>Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)</em>
594-
</li><li>Allow INSERT/UPDATE ... RETURNING new.col or old.col
595-
<p> This is useful for returning the auto-generated key for an INSERT.
596-
One complication is how to handle rules that run as part of
597-
the insert.
598-
<a href="http://archives.postgresql.org/pgsql-patches/2005-07/msg00568.php">http://archives.postgresql.org/pgsql-patches/2005-07/msg00568.php</a>
599-
<li>In rules, allow VALUES() to contain a mixture of 'old' and 'new'
594+
</li><li>-<em>Allow INSERT/UPDATE ... RETURNING new.col or old.col</em>
595+
</li><li>In rules, allow VALUES() to contain a mixture of 'old' and 'new'
600596
references
601597
</li></ul>
602-
<li>SHOW/SET
598+
</li><li>SHOW/SET
603599
<ul>
604600
<li>Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM
605601
ANALYZE, and CLUSTER
@@ -677,7 +673,7 @@ <h1><a name="section_8">SQL Commands</a></h1>
677673
</li></ul>
678674
</li></ul>
679675
</li></ul>
680-
</p><h1><a name="section_9">Clients</a></h1>
676+
<h1><a name="section_9">Clients</a></h1>
681677

682678
<ul>
683679
<li>-<em>Have initdb set the input DateStyle (MDY or DMY) based on locale</em>
@@ -1337,6 +1333,6 @@ <h2><a name="section_23_1">Developers who have claimed items are:</a></h2>
13371333
</li><li>Teodor is Teodor Sigaev &lt;<a href="mailto:teodor@sigaev.ru">teodor@sigaev.ru</a>&gt;
13381334
</li><li>Tom is Tom Lane &lt;<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; of Red Hat
13391335
</li></ul>
1340-
</li></ul></li></ul>
1336+
13411337
</body>
13421338
</html>

0 commit comments

Comments
 (0)