Re: Modification Dates

From: Sven Schwyn <zeug(at)bluewin(dot)ch>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Modification Dates
Date: 2003-09-29 12:36:00
Message-ID: 7B5823F7-F279-11D7-BD02-00039398CFBA@bluewin.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi again

Got it, quite obvious too. The trigger has to be called BEFORE the
UPDATE, not AFTER. (Hmmm, very obvious even.)

CREATE TRIGGER _modified BEFORE UPDATE ON any_table FOR EACH ROW
EXECUTE PROCEDURE
touch();

That does the trick!

Greets, -sven

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-09-29 13:22:23 Re: Time problem again?
Previous Message btober 2003-09-29 12:35:55 Where are user-defined types stored/viewed