
Dear hackers,

a small inconsistency with the syntax of any/all as describe from the
documentation. One can write:

psql> SELECT 'foo' ~~ ANY (ARRAY['%a%','%o%']);

although the following yields a syntax error, even if LIKE is an operator,
thus it should be allowed.

psql> SELECT 'foo' LIKE ANY (ARRAY['%a%','%o%']);

IMHO, it would make sense to allow the later unless some critical parser
implication, as an average user (say, me;-) would try that before the
first one.

=> Add to todo list?

Have a nice day,

-- 
Fabien Coelho - coelho@cri.ensmp.fr

Tue, 23 Mar 2004 09:52:45 +0100 (CET)
Fabien COELHO <coelho@cri.ensmp.fr>
LIKE ANY and the like?