Commit61dd737

committed

Document DELETE/UPDATE command tag behavior when triggers are involved.

Marti Raudsepp

1 parent0ff7ea5 commit61dd737Copy full SHA for 61dd737

File tree

+12

-8

lines changed

+12

-8

lines changed

Lines changed: 6 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -206,10 +206,12 @@ DELETE FROM [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ [ AS ]`
`206`	`206`	`DELETE <replaceable class="parameter">count</replaceable>`
`207`	`207`	`</screen>`
`208`	`208`	`The <replaceable class="parameter">count</replaceable> is the number`
`209`		`- of rows deleted. If <replaceable class="parameter">count</replaceable> is`
`210`		`- 0, no rows matched the <replaceable`
`211`		`- class="parameter">condition</replaceable> (this is not considered`
`212`		`- an error).`
	`209`	`+ of rows deleted. Note that the number may be less than the number of`
	`210`	`+ rows that matched the <replaceable`
	`211`	`+ class="parameter">condition</replaceable> when deletes were`
	`212`	`+ suppressed by a <literal>BEFORE DELETE</> trigger. If <replaceable`
	`213`	`+ class="parameter">count</replaceable> is 0, no rows were deleted by`
	`214`	`+ the query (this is not considered an error).`
`213`	`215`	`</para>`
`214`	`216`
`215`	`217`	`<para>`

Lines changed: 6 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -226,10 +226,12 @@ UPDATE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ [ AS ] <rep`
`226`	`226`	`UPDATE <replaceable class="parameter">count</replaceable>`
`227`	`227`	`</screen>`
`228`	`228`	`The <replaceable class="parameter">count</replaceable> is the number`
`229`		`- of rows updated. If <replaceable class="parameter">count</replaceable> is`
`230`		`- 0, no rows matched the <replaceable`
`231`		`- class="parameter">condition</replaceable> (this is not considered`
`232`		`- an error).`
	`229`	`+ of rows updated, including matched rows whose values did not change.`
	`230`	`+ Note that the number may be less than the number of rows that matched`
	`231`	`+ the <replaceable class="parameter">condition</replaceable> when`
	`232`	`+ updates were suppressed by a <literal>BEFORE UPDATE</> trigger. If`
	`233`	`+ <replaceable class="parameter">count</replaceable> is 0, no rows were`
	`234`	`+ updated by the query (this is not considered an error).`
`233`	`235`	`</para>`
`234`	`236`
`235`	`237`	`<para>`

Comments

(0)