| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Josep Sanmartí <josep(dot)sanmarti(at)openwired(dot)net> |
| Cc: | William Leite Araújo <william(dot)bh(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Trigger on a column |
| Date: | 2006-02-06 11:01:34 |
| Message-ID: | 43E72C8E.7020607@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karsten Hilbert | 2006-02-06 11:29:09 | Re: Function Dependency |
| Previous Message | Josep Sanmartí | 2006-02-06 10:48:06 | Re: Trigger on a column |