Re: Rules

On Wed, 28 Nov 2001, Albert Bartoszko wrote:

> AFAIR  (Postgres 6.5 - 7.1.3):
>
> cd /usr/src/postgresql-X.X.X/src/interfaces/libpq++/examples
> [postgres@xxx examples]$ /usr/local/pgsql/bin/psql
> Password:
> Welcome to psql, the PostgreSQL interactive terminal.
>
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help on internal slash commands
>        \g or terminate with semicolon to execute query
>        \q to quit
>
> postgres=# \i testlibpq2.sql
> CREATE
> CREATE
> psql:testlibpq2.sql:5: ERROR:  parser: parse error at or near ""
> psql:testlibpq2.sql:5: ERROR:  parser: parse error at or near "]"
> postgres=# \q
> [postgres@komuna examples]$ cat testlibpq2.sql
> CREATE TABLE TBL1 (i int4);
>
> CREATE TABLE TBL2 (i int4);
>
> CREATE RULE r1 AS ON INSERT TO TBL1 DO [INSERT INTO TBL2 values (new.i);
> NOTIFY TBL2];

It works for me with () rather than [], although both are in the help.