diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-12-01 22:12:35 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-12-01 22:12:35 +0000 |
| commit | 915fb7f687bd6553ec6466776f6eb1d6b81fbfcc (patch) | |
| tree | c66b0387c2ad7a8932842d8bf80064cd48b0a9c8 /doc/TODO | |
| parent | f28bdd95c1755027756914d7d46424287e192e9e (diff) | |
| download | postgresql-915fb7f687bd6553ec6466776f6eb1d6b81fbfcc.tar.gz | |
Add MERGE TODO.detail:
> [merge]
378a380
> [merge]
Diffstat (limited to 'doc/TODO')
| -rw-r--r-- | doc/TODO | 4 |
1 files changed, 3 insertions, 1 deletions
@@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Thu Dec 1 17:07:44 EST 2005 +Last updated: Thu Dec 1 17:12:27 EST 2005 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -370,12 +370,14 @@ SQL Commands * Add a GUC variable to warn about non-standard SQL usage in queries * Add SQL-standard MERGE command, typically used to merge two tables + [merge] This is similar to UPDATE, then for unmatched rows, INSERT. Whether concurrent access allows modifications which could cause row loss is implementation independent. * Add REPLACE or UPSERT command that does UPDATE, or on failure, INSERT + [merge] To implement this cleanly requires that the table have a unique index so duplicate checking can be easily performed. It is possible to |