> > I assume you mean:
> >
> > test=> select (;)
> > ERROR: parser: parse error at or near ")"
>
> Kinda,
>
> actually I meant
>
> CREATE RULE myrule AS ON DELETE TO mytable DO (
> DELETE FROM myothertab1 WHERE key = old.key;
> DELETE FROM myothertab2 WHERE key = old.key;
> );
> ERROR: parser: parse error at or near ""
>
> This is a possible syntax which (IIRC) got released with v6.4
> and is subject to the examples in the rule system
> documentation. The parser still accepts it, so breaking it
> due to changes in psql is an IMHO unacceptable backward
> incompatibility.
OK, I fixed it. Just one addition test in an _if_ statement.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026