Thread: release notes

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

Selena Deckelmann wrote:
> 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)

Thanks, fixed.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com