Re: [SQL] Adding a rule to update a last_changed field - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Adding a rule to update a last_changed field
Date
Msg-id 20774.940607126@sss.pgh.pa.us
Whole thread Raw
In response to Adding a rule to update a last_changed field  (grant@intekom.com)
List pgsql-sql
grant@intekom.com writes:
> I'm trying to use a rule to maintain a last_changed field. 

Use a trigger, not a rule.  You can adjust the last_changed
field before the tuple is stored that way.  There's an example
in the manual's discussion of triggers.
        regards, tom lane


pgsql-sql by date:

Previous
From: Brook Milligan
Date:
Subject: Re: [SQL] Adding a rule to update a last_changed field
Next
From: Grant Kaufmann
Date:
Subject: Re: [SQL] Adding a rule to update a last_changed field