Re: update in rule

*** Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> [Wednesday, 17.October.2001, 12:04 -0700]:
> create function adresses_trigger() returns opaque as '
> begin
> NEW.date_maj := now();
> return NEW;
> end;' language 'plpgsql';
> create trigger tr before update on adresses for each row execute
> procedure adresses_trigger();

why sould I use before (instead of after)?
isnt it a little dangerous in transactions? /hope not/

I know difference between both forms. The question is rather about if
timestamp updating shouldnt be run AFTER update which I think is closer
to a real world situations (of course evth vary). But maybe there are
some probles with after, which I dont know about?

Just being curious...

--
radoslaw.stachowiak.........................................http://alter.pl/