pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Richard Huxton <dev@archonet.com>
To: Josep Sanmartí <josep.sanmarti@openwired.net>
Cc: William Leite Araújo <william.bh@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Trigger on a column
Date: Mon, 06 Feb 2006 11:01:34 +0000
Message-ID: <43E72C8E.7020607@archonet.com> (raw)
In-Reply-To: <43E72966.4090100@openwired.net>
References: <43E71A6C.6070104@openwired.net>
<bc63ad820602060224m6e1a75fel@mail.gmail.com>
<43E72966.4090100@openwired.net>
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
view thread (3+ messages)
Message-ID: <43E72C8E.7020607@archonet.com> Permalink: ../43E72C8E.7020607@archonet.com/ Also on: postgresql.org/message-id/43E72C8E.7020607@archonet.com ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-sql@postgresql.org Cc: dev@archonet.com, josep.sanmarti@openwired.net, william.bh@gmail.com Subject: Re: Trigger on a column In-Reply-To: <43E72C8E.7020607@archonet.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox