Operators LIKE and SIMILAR TO work differently This query works ok.:
SELECT * FROM www.test WHERE expr like any (ARRAY['a','b']);
But this not work:
SELECT * FROM www.test WHERE expr similar to any (ARRAY['a','b']);
ERROR: syntax error at or near "any" LINE 3: WHERE expr similar to any (ARRAY['a','b']);
Is this shouldn't works ?
SIMILAR TO and LIKE aren't synonyms for each other. SIMILAR TO uses a cross between LIKE syntax and regular expressions for the evalutated expression. I'm not entirely sure what your query is supposed to be doing. I thought ANY was a keyword denoting a row-wise comparison?