Re: Auto-updated fields

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: David Fetter <david(at)fetter(dot)org>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Auto-updated fields
Date: 2008-05-08 06:44:46
Message-ID: 20080508064446.GA16326@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Achilleas Mantzios 2008-05-08 07:09:48 dbmirror - migration to 8.3 from 7.4
Previous Message KaiGai Kohei 2008-05-08 06:06:51 Re: [0/4] Proposal of SE-PostgreSQL patches