Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit510aad3

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 parentaeb056f commit510aad3

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 1116:17:22 EDT 2006
5+
Last updated:Fri Aug 1123: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
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated: Fri Aug 1116:17:22 EDT 2006
11+
Last updated: Fri Aug 1123:50:26 EDT 2006
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="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-
<ahref="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><aname="section_9">Clients</a></h1>
676+
<h1><aname="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;<ahref="mailto:teodor@sigaev.ru">teodor@sigaev.ru</a>&gt;
13381334
</li><li>Tom is Tom Lane &lt;<ahref="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)
[8]ページ先頭
©2009-2025 Movatter.jp