Re: [HACKERS] updating on views

2002-11-26 Thread Gavin Sherry
On Tue, 26 Nov 2002, Stephan Szabo wrote: > Well, it depends. SQL updatable views are fairly limited from what I > remember and the general write your own update rules is much broader, so I > doubt anyone got terribly excited by doing the limited version. It would > take some work to define what

Re: [HACKERS] updating on views

2002-11-26 Thread Stephan Szabo
On Wed, 27 Nov 2002, XiaojingLi wrote: > I'd like to bother you with something about updating views. At > present, postgresql7.3¡¡doesn't support update on views.When I look up It does if you provide the rules for what it means to do the update (and there are some wierd issues with delete,

[HACKERS] updating on views

2002-11-26 Thread XiaojingLi
Hi! I'd like to bother you with something about updating views. At present, postgresql7.3¡¡doesn't support update on views.When I look up the source code, I see that view is implemented with rules. That is when a view is created, a corresponding ¡®select'¡¡rule is created too. A