View Single Post

   
  #3 (permalink)  
Old 05-10-2008, 03:05 PM
Martijn van Oosterhout
 
Posts: n/a
Default 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.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIIqFeIB7bNG8LQkwRAlAeAJ4qc/z9RYx7w4puVWBFdmuY0gbuTACggwUH
C+5HeH8/wc9aYoaLK5oaeyc=
=j4XC
-----END PGP SIGNATURE-----

Reply With Quote