2010/6/15 Rosiński Krzysztof 2 - Detal TP <Krzysztof.Rosinski2@xxxxxxxxxxxxxxxxxx>
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?
Thom
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 ?
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?
Thom
