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 - [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster