Re: Trigger.. AFTER and BEFORE with specific column changed

From: Albert <oo_O2_oo(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger.. AFTER and BEFORE with specific column changed
Date: 2012-04-02 05:10:08
Message-ID: 1333343408489-5611501.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

*i get:*

Syntax error at or near 'WHEN'
LINE 1: ... check_update AFTER UPDATE ON accounts FOR EACH ROW WHEN
(OLD.balance IS DISTINCT FROM NEW.balance) ....

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Trigger-AFTER-and-BEFORE-with-specific-column-changed-tp5610712p5611501.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2012-04-02 05:33:56 Re: Switching to Homebrew as recommended Mac install?
Previous Message Jay Levitt 2012-04-02 04:50:31 Re: Switching to Homebrew as recommended Mac install?