Re: Update rule on a view - what am I doing wrong - Mailing list pgsql-general

   Hi Marc,

    Thanks a lot. That works fine. The names 'NEW' and 'OLD' works fine.

 Leif


----- "Marc Schablewski" <ms@clickware.de> wrote:

> Hi Leif,
>
> Am 22.01.2013 14:34, schrieb Leif Jensen:
>
>
> CREATE update_rule_func( old record, new record ) AS ...  I am told,
> that I cannot use record for the parameter type. Could you please You
> should use your view instead of 'record' as parameter type, i.e.
> CREATE update_rule_func( old V_YOUR_VIEW, new V_YOUR_VIEW ) AS ... .
> Also, I'm not sure if 'new' and 'old' are reserved keywords in
> PostgreSQL, so you might want to choose different names for your
> parameters if you still have trouble with that function.
>
> Marc