Re: Trigger on a column - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Trigger on a column
Date
Msg-id 43E72C8E.7020607@archonet.com
Whole thread Raw
In response to Re: Trigger on a column  (Josep Sanmartí <josep.sanmarti@openwired.net>)
List pgsql-sql
Josep Sanmartí wrote:
> Hi,
>
> readding around I just found this:
> The CREATE TRIGGER statement in PostgreSQL implements a subset of the
> SQL99 standard. (There are no provisions for triggers in SQL92.) The
> following functionality IS MISSING:
> * SQL99 allows triggers to fire on updates to specific columns (e.g.,
> AFTER UPDATE OF col1, col2).
> * .....
>
> Does anybody know if that's true on version postgresql (PostgreSQL)
> 8.1.2? Because I don't actually know from what version that sentence is.

Yes it is true for the current version.

Up-to-date documentation always ships with a release and is also
available on the website.

--   Richard Huxton  Archonet Ltd



pgsql-sql by date:

Previous
From: Josep Sanmartí
Date:
Subject: Re: Trigger on a column
Next
From: Karsten Hilbert
Date:
Subject: Re: Function Dependency