Re: How can I write trigger on a columns insert/update?

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: dpandey(at)secf(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: How can I write trigger on a columns insert/update?
Date: 2005-05-20 17:17:50
Message-ID: 1116609471.24440.2143.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2005-05-19 at 04:35, Richard Huxton wrote:
> Dinesh Pandey wrote:
> > How can I write trigger on a columns insert/update?
> >
> > CREATE TRIGGER mytrigger
> > BEFORE
> > INSERT OR UPDATE
> > OF mycolumn ON mytable
>
> You don't I'm afraid. It's not a feature that's supported yet. You have
> to check which column(s) were changed in your functions.
>
> It is on the TODO list though:
> http://www.postgresql.org/docs/faqs.TODO.html
>

Just to add there is someone working on this for 8.1, hopefully it will
get done. Also the workaround is to create a regular trigger and then do
a check in the function

IF NEW.mycol <> OLD.mycol THEN... it's not quite as spiff but should do
what you want.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Claudio Succa 2005-05-20 17:19:50 Re: numeric precision when raising one numeric to
Previous Message Tom Lane 2005-05-20 17:03:08 Re: numeric precision when raising one numeric to another.