Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> 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