Re: Update and Insert in a View Insert Rule

On Tue, 2002-05-21 at 18:19, Stephan Szabo wrote:
> On 21 May 2002, Tom Jenkins wrote:
> >
> > unfortunately this gives me an error when I attempt to load the rule I
> > get:
> > ERROR:  NEW used in non-rule query
> >
> > I don't understand why this wouldn't work.  Unless it has something to
> > do with NEW getting "lost" in the update call?  should i move the update
> > out to a function and calling it from the rule?
>
> I think you forgot to use the () around the multiple actions.
> It should probably be:
> DO INSTEAD (
>  ...
> );
>

AAAARRRRRGGGGGGHHHHHHH!!!
*sigh* up that was the problem.  Funny how you can stare at something
and not actually see it.  Thanks


--

Tom Jenkins
Development InfoStructure
http://www.devis.com