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(at)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(at)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.