Re: Triggers on columns - Mailing list pgsql-hackers

From James Pye
Subject Re: Triggers on columns
Date
Msg-id F891E97B-4FE8-49B5-98EF-24CA786ABC8C@jwp.name
Whole thread Raw
In response to Re: Triggers on columns  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Triggers on columns
List pgsql-hackers
On Sep 8, 2009, at 5:33 PM, Itagaki Takahiro wrote:
> WHEN clause in other times [1][2][3]. (All of them use "WHEN" for the
> syntax; that's why I proposed "WHEN" but not "WHERE".)

Well, looks like WHEN is, or is going to be standard:

<triggered action> ::=
[ FOREACH { ROW | STATEMENT } ]    [ WHEN<left paren><search condition> <right paren> ]
<triggered SQL statement>

(page 653 from 5CD2-02-Foundation-2006-01)


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: ecpg build failed on CVS HEAD
Next
From: Tom Lane
Date:
Subject: Re: ecpg build failed on CVS HEAD