Re: Auto-updated fields - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Auto-updated fields
Date
Msg-id 20080508064446.GA16326@svana.org
Whole thread Raw
In response to Auto-updated fields  (David Fetter <david@fetter.org>)
Responses Re: Auto-updated fields  (Zoltan Boszormenyi <zb@cybertec.at>)
Re: Auto-updated fields  (David Fetter <david@fetter.org>)
List pgsql-hackers
On Wed, May 07, 2008 at 03:04:49PM -0700, David Fetter wrote:
> 1.  Create a generic (possibly overloaded) trigger function, bundled
> with PostgreSQL, which sets a field to some value.  For example, a
> timestamptz version might set the field to now().

Doesn't the SQL standard GENERATED BY functionality work for this? Or
won't that handle updates?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

pgsql-hackers by date:

Previous
From: KaiGai Kohei
Date:
Subject: Re: [0/4] Proposal of SE-PostgreSQL patches
Next
From: Achilleas Mantzios
Date:
Subject: dbmirror - migration to 8.3 from 7.4