Re: Rules

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Peeter Smitt <peeter(dot)smitt(at)online(dot)ee>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Rules
Date: 2000-12-31 12:18:30
Message-ID: Pine.LNX.4.30.0012311317440.776-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net http://yi.org/peter-e/

In response to

  • Rules at 2000-11-09 08:50:44 from Peeter Smitt

Browse pgsql-sql by date

  From Date Subject
Next Message Ferruccio Zamuner 2000-12-31 14:55:12 Unable to identify an ordering operator
Previous Message Thomas SMETS 2000-12-31 01:25:51 Re: Looking for comments