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