Re: Updating views

>  Problem is not 'where'. Views in Postgresql doesn't allows you insert,
>  update or delete unless you define especila rules that explain Postgresql
>  what to do in each case.
>  Look Postgresql programming manual. You can see a few examples of rules in
>  views.

OK, but I can't see how to make a single rule that allows me to update
an arbitray set of attributes from an arbitray where-clause.

Example:
I have a table named 'extable(a,b,c,d)' and a view 'exview(b,c,d)' for
this table. How can I with a single rule allow the following updates:
  update exview set b=10, c=0 where d=11;
  update exview set b=0 where c > d;
  update exview set d=123 where b=c and c=d;

In other words: I want to make the update of 'exview' transparent to
'extable'.

--
Rasmus Resen Amossen | stud.mat.dat at the University of Copenhagen
Jagtvej 120, -244    | http://www.math.ku.dk/muh
2200 Kbh. N          | http://w1.1444.telia.com/~u144400001