diff options
| author | Robert Haas <rhaas@postgresql.org> | 2011-10-10 12:53:04 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2011-10-10 12:53:04 -0400 |
| commit | 61dd737c29661763448d61786ec1aa260db0412a (patch) | |
| tree | 433e267b44fa399fd1bf9c05f7dde7bf2ae115db /doc/src | |
| parent | 0ff7ea5d3c6d126ba9fd05ea1845d49e8c0b4fd9 (diff) | |
| download | postgresql-61dd737c29661763448d61786ec1aa260db0412a.tar.gz postgresql-61dd737c29661763448d61786ec1aa260db0412a.zip | |
Document DELETE/UPDATE command tag behavior when triggers are involved.
Marti Raudsepp
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/delete.sgml | 10 | ||||
| -rw-r--r-- | doc/src/sgml/ref/update.sgml | 10 |
2 files changed, 12 insertions, 8 deletions
diff --git a/doc/src/sgml/ref/delete.sgml b/doc/src/sgml/ref/delete.sgml index 71ebeda880a..6366b158118 100644 --- a/doc/src/sgml/ref/delete.sgml +++ b/doc/src/sgml/ref/delete.sgml @@ -206,10 +206,12 @@ DELETE FROM [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ [ AS ] DELETE <replaceable class="parameter">count</replaceable> </screen> The <replaceable class="parameter">count</replaceable> is the number - of rows deleted. If <replaceable class="parameter">count</replaceable> is - 0, no rows matched the <replaceable - class="parameter">condition</replaceable> (this is not considered - an error). + of rows deleted. Note that the number may be less than the number of + rows that matched the <replaceable + class="parameter">condition</replaceable> when deletes were + suppressed by a <literal>BEFORE DELETE</> trigger. If <replaceable + class="parameter">count</replaceable> is 0, no rows were deleted by + the query (this is not considered an error). </para> <para> diff --git a/doc/src/sgml/ref/update.sgml b/doc/src/sgml/ref/update.sgml index ba5af8e884b..1c0e21536b1 100644 --- a/doc/src/sgml/ref/update.sgml +++ b/doc/src/sgml/ref/update.sgml @@ -226,10 +226,12 @@ UPDATE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ [ AS ] <rep UPDATE <replaceable class="parameter">count</replaceable> </screen> The <replaceable class="parameter">count</replaceable> is the number - of rows updated. If <replaceable class="parameter">count</replaceable> is - 0, no rows matched the <replaceable - class="parameter">condition</replaceable> (this is not considered - an error). + of rows updated, including matched rows whose values did not change. + Note that the number may be less than the number of rows that matched + the <replaceable class="parameter">condition</replaceable> when + updates were suppressed by a <literal>BEFORE UPDATE</> trigger. If + <replaceable class="parameter">count</replaceable> is 0, no rows were + updated by the query (this is not considered an error). </para> <para> |