Re: Define update-rule on view

patriq(at)gmx(dot)de (Patrick) writes:
> i created a working rule for insert on the view.
> now i want to implement a rule for an update.
> the task is, that an update doesnt "update" the selected entry, it got
> to set test_active to false, and insert a new row with the new data
> and test_active settet to true.

I don't believe you can do that with a rule --- you'll run into a
recursive-rule-application problem. You could do it with a trigger,
but perhaps better is to reconsider your table design. Seems like
it might be better to have two tables, one containing the active
entries and one containing the historical ones.

regards, tom lane