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
- Re: [HACKERS] ALL, ANY bug? Tatsuo Ishii
- Re: [HACKERS] ALL, ANY bug? Tom Lane
- Re: [HACKERS] ALL, ANY bug? Tatsuo Ishii
- Re: [HACKERS] ALL, ANY bug? Tom Lane
- Re: [HACKERS] ALL, ANY bug? Tatsuo Ishii