Postgres Pro
Downloads
Home   >   mailing lists

Re: Modification Dates - Mailing list pgsql-general

From Doug McNaught
Subject Re: Modification Dates
Date
Msg-id m3pthjmw2t.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Re: Modification Dates  (Sven Schwyn <zeug@bluewin.ch>)
List pgsql-general
Tree view 
Sven Schwyn <zeug@bluewin.ch> writes:

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

You want BEFORE UPDATE here.  AFTER UPDATE happens, well, after the
update.  :)

-Doug

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Where are user-defined types stored/viewed
Next
From: "Andrew L. Gould"
Date:
Subject: Re: Access - can't close Form