While below is ok:

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);

but this fails:

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 ">"

Does anybody know why?
--
Tatsuo Ishii

Reply via email to