Re: Update instead rules on Views

Helo,

On Tue, 2 Nov 2004 13:05:07 +0100
Markus Schaber <schabios(at)logi-track(dot)com> wrote:

> -- But to remain compatibility with old apps, we also need to manage
> -- updates to the view, which are to be rewritten as follows:
> CREATE RULE testview_update_rule
> AS ON UPDATE TO testview DO INSTEAD
> UPDATE realdata SET
> index = NEW.index,
> data = NEW.data,
> obsolete=NULL
> ;

I now got it to work with adding a "WHERE index=NEW.index" to the view.

Am I correct in my assumption that this means that this only works when
I have a primary key (or at least unique) row in my dataset?

Thanks,
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios(at)logi-track(dot)com | www.logi-track.com