Search Postgresql Archives

Re: Update rule on a view - what am I doing wrong

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



   Hi Marc,

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

 Leif


----- "Marc Schablewski" <ms@xxxxxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux