Commitb218857

committed

Fix example on creating a trigger with a transition table.

1 parent8efd1e0 commitb218857Copy full SHA for b218857

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -531,8 +531,8 @@ CREATE TRIGGER view_insert`
`531`	`531`	`<programlisting>`
`532`	`532`	`CREATE TRIGGER transfer_insert`
`533`	`533`	`AFTER INSERT ON transfer`
`534`		`- FOR EACH STATEMENT`
`535`	`534`	`REFERENCING NEW TABLE AS inserted`
	`535`	`+ FOR EACH STATEMENT`
`536`	`536`	`EXECUTE PROCEDURE check_transfer_balances_to_zero();`
`537`	`537`	`</programlisting>`
`538`	`538`
`@@ -543,8 +543,8 @@ CREATE TRIGGER transfer_insert`
`543`	`543`	`<programlisting>`
`544`	`544`	`CREATE TRIGGER paired_items_update`
`545`	`545`	`AFTER UPDATE ON paired_items`
`546`		`- FOR EACH ROW`
`547`	`546`	`REFERENCING NEW TABLE AS newtab OLD TABLE AS oldtab`
	`547`	`+ FOR EACH ROW`
`548`	`548`	`EXECUTE PROCEDURE check_matching_pairs();`
`549`	`549`	`</programlisting>`
`550`	`550`	`</para>`

Comments

(0)