Hello.
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 ?
pasman