ALL, ANY bug? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject ALL, ANY bug?
Date
Msg-id 20010108103209Y.t-ishii@sra.co.jp
Whole thread Raw
Responses Re: ALL, ANY bug?
List pgsql-hackers
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,
compiledby GCC egcs-2.91.66
 
(1 row)

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


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: RE: Suggested fix for pg_dump
Next
From: Marko Kreen
Date:
Subject: Re: patch: contrib/pgcrypto sanity