PFC <lists(at)boutiquenumerique(dot)com> writes:
> You can create an ON UPDATE/INSERT trigger on a view which intercepts the
> UPDATE/INSERT to the view (which would otherwise fail) and do whatever you
> want with it, including doing the operation on the real table.
This might work for INSERT but I really doubt it'll work for UPDATE or
You may be able to make it work with rules, though there are lots of
pitfalls in that approach.
regards, tom lane
In response to
pgsql-sql by date
|Next:||From: Michael Fuhr||Date: 2005-02-16 23:47:13|
|Subject: Re: Trigger|
|Previous:||From: PFC||Date: 2005-02-16 21:27:03|
|Subject: Re: Order of columns in a table important in a stored procedure?|