> On Fri, May 26, 2006 at 12:02:44PM +0500, kmi(at)st(dot)uz wrote:
>> I have trigger on updating the table. Sometimes i need to make queries
>> without calling that trigger. How can I solve this?
>
> You need your function to decide whether the "don't do anything"
> conditions apply, and then not do anything. The trigger still fires,
> but it doesn't do anything.
>
> A
>
> --
> Andrew Sullivan | ajs(at)crankycanuck(dot)ca
> "The year's penultimate month" is not in truth a good way of saying
> November.
> --H.W. Fowler
>
Yep, decided the best way to ignore trigger is checking function in
trigger body. In my "Updating" case i used checking (old.fieldname <>
new.fieldname).