|
8 | 8 | <bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF"> |
9 | 9 | <h1><aname="section_1">PostgreSQL TODO List</a></h1> |
10 | 10 | <p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/> |
11 | | -Last updated: Thu Dec 1 17:07:44 EST 2005 |
| 11 | +Last updated: Thu Dec 1 17:12:27 EST 2005 |
12 | 12 | </p> |
13 | 13 | <p>The most recent version of this document can be viewed at<br/> |
14 | 14 | <ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>. |
@@ -340,11 +340,13 @@ <h1><a name="section_8">SQL Commands</a></h1> |
340 | 340 | </p> |
341 | 341 | </li><li>Add a GUC variable to warn about non-standard SQL usage in queries |
342 | 342 | </li><li>Add SQL-standard MERGE command, typically used to merge two tables |
| 343 | + [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?merge">merge</a>] |
343 | 344 | <p> This is similar to UPDATE, then for unmatched rows, INSERT. |
344 | 345 | Whether concurrent access allows modifications which could cause |
345 | 346 | row loss is implementation independent. |
346 | 347 | </p> |
347 | 348 | </li><li>Add REPLACE or UPSERT command that does UPDATE, or on failure, INSERT |
| 349 | + [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?merge">merge</a>] |
348 | 350 | <p> To implement this cleanly requires that the table have a unique index |
349 | 351 | so duplicate checking can be easily performed. It is possible to |
350 | 352 | do it without a unique index if we require the user to LOCK the table |
|