Re: Auto-updated fields

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.