It seems ALL and ANY (SOME) have problems with the parser.

test=# select * from t1 where i <> all(0,1);
ERROR:  parser: parse error at or near "0"
test=# select * from t1 where i = any (0,1);
ERROR:  parser: parse error at or near "0"
test=# select version();
                                version                                 
------------------------------------------------------------------------
 PostgreSQL 7.1beta2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)

Note that if (0,1) is a subselect, it works fine.
--
Tatsuo Ishii

Reply via email to