diff options
| author | Bruce Momjian | 2005-12-01 22:07:59 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2005-12-01 22:07:59 +0000 |
| commit | 24e1a045915215a7276d80654731a9823801558b (patch) | |
| tree | 37db181e6fd080ae857f2f657d71b42e3d468e7e /doc/TODO | |
| parent | 8c8c0108e8f39b291286eaf3cc5c482ecc305f48 (diff) | |
Split out MERGE and REPLACE/UPSERT items.
< * Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules,
< triggers?)
> * Add SQL-standard MERGE command, typically used to merge two tables
>
> 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
Diffstat (limited to 'doc/TODO')
| -rw-r--r-- | doc/TODO | 11 |
1 files changed, 8 insertions, 3 deletions
@@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Mon Nov 28 21:02:36 EST 2005 +Last updated: Thu Dec 1 17:07:44 EST 2005 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -369,8 +369,13 @@ SQL Commands information. * Add a GUC variable to warn about non-standard SQL usage in queries -* Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules, - triggers?) +* Add SQL-standard MERGE command, typically used to merge two tables + + 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 To implement this cleanly requires that the table have a unique index so duplicate checking can be easily performed. It is possible to |