Re: subselect bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: subselect bug?
Date
Msg-id 25440.979571172@sss.pgh.pa.us
Whole thread Raw
In response to subselect bug?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.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


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: subselect bug?
Next
From: tolik@aaanet.ru (Anatoly K. Lasareff)
Date:
Subject: locale and multibyte together in 7.1