In section:
E.1.3.6.4. Function and Trigger Creation
This:
> Add WHERE clause to CREATE TRIGGER to allow control over whether a trigger is fired (Takahiro Itagaki)
> While a check can be performed inside the trigger, doing it in an external WHERE clause has performance benefits.
Should be:
> Add WHEN clause to CREATE TRIGGER to allow control over whether a trigger is fired (Takahiro Itagaki)
> While a check can be performed inside the trigger, doing it in an external WHEN clause has performance benefits.
For reference: http://developer.postgresql.org/pgdocs/postgres/sql-createtrigger.html
(also, Gabrielle & I used this in our 'what's sweet in 9.0' talk at LFNW)
-selena
--
http://chesnok.com/daily - me
http://endpoint.com - work