Re: Rules - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Rules
Date
Msg-id Pine.LNX.4.30.0012311317440.776-100000@peter.localdomain
Whole thread Raw
In response to Rules  ("Peeter Smitt" <peeter.smitt@online.ee>)
List pgsql-sql
Peeter Smitt writes:

> CREATE RULE update_rule AS ON UPDATE TO table DO INSTEAD
>   SELECT fun1(new);
>
> Thing is that backend gives this error.
>   ERROR:  parser: parse error at or near ")"

Try double quoting "new", since it's a reserved word.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-sql by date:

Previous
From: "Peeter Smitt"
Date:
Subject: Rules
Next
From: Ferruccio Zamuner
Date:
Subject: Unable to identify an ordering operator