Re: Trigger with WHEN clause (WIP) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Trigger with WHEN clause (WIP)
Date
Msg-id 29065.1255617414@sss.pgh.pa.us
Whole thread Raw
In response to Trigger with WHEN clause (WIP)  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Trigger with WHEN clause (WIP)
Re: Trigger with WHEN clause (WIP)
List pgsql-hackers
Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> I think there is a benefit to provide WHEN cluase at least
> for compatibility with other DBMSs, even through we can move
> the expressions into the body of trigger functions.

This seems to me to be a lot of code to accomplish nothing useful.
It will always be the case that any nontrivial logic has to be done
inside the trigger.  And the compatibility argument is entirely
pointless given the lack of compatibility in the trigger function
itself.

-1
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Client application name
Next
From: Dave Page
Date:
Subject: Re: Client application name