Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger.. AFTER and BEFORE with specific column changed - Mailing list pgsql-general

From Albert
Subject Re: Trigger.. AFTER and BEFORE with specific column changed
Date
Msg-id 1333343408489-5611501.post@n5.nabble.com
Whole thread Raw
In response to Trigger.. AFTER and BEFORE with specific column changed  (Albert <oo_O2_oo@hotmail.com>)
Responses Re: Trigger.. AFTER and BEFORE with specific column changed  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Trigger.. AFTER and BEFORE with specific column changed  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Trigger.. AFTER and BEFORE with specific column changed  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
Tree view 
*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.

pgsql-general by date:

Previous
From: Martin Gregorie
Date:
Subject: Re: Versioned, chunked documents
Next
From: "Albe Laurenz"
Date:
Subject: Re: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.