Re: [GENERAL] Re: Updating views

2001-06-06 Thread will trillich
On Tue, Jun 05, 2001 at 01:17:00AM +0200, Rasmus Resen Amossen wrote: > > 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. Yo

Re: [GENERAL] Re: Updating views

2001-06-04 Thread Tom Lane
Rasmus Resen Amossen <[EMAIL PROTECTED]> writes: > 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. The reason the system doesn't do that for you is that it's *hard* to figure out what to do for an arbitrary wher

Re: [GENERAL] Re: Updating views

2001-06-04 Thread Stephan Szabo
On Tue, 5 Jun 2001, Rasmus Resen Amossen wrote: > > 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 exam

[GENERAL] Re: Updating views

2001-06-04 Thread Rasmus Resen Amossen
> 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 mak