Re: [HACKERS] subselect bug?

[Tom Lane]

Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> select * from table_a a
>     where ((select data_a from table_a where id = a.id) >
>            (select data_b from table_a where id = a.id));

> ERROR:  parser: parse error at or near ">"

Ugh.  The grammar does some pretty squirrely things with parentheses
around selects, and I guess it's getting confused on this.  Don't
know why offhand ...

                        regards, tom lane