Re: Inconsistency with LIKE and SIMILAR TO
От | Thom Brown |
---|---|
Тема | Re: Inconsistency with LIKE and SIMILAR TO |
Дата | |
Msg-id | AANLkTikt5esJ1LEVRWDalQh70iK9S9fi1zUiMqeYvZ6C@mail.gmail.com обсуждение исходный текст |
Ответ на | Inconsistency with LIKE and SIMILAR TO (Rosiński Krzysztof 2 - Detal TP<Krzysztof.Rosinski2@telekomunikacja.pl>) |
Ответы |
Re: Inconsistency with LIKE and SIMILAR TO
|
Список | pgsql-general |
2010/6/15 Rosiński Krzysztof 2 - Detal TP <Krzysztof.Rosinski2@telekomunikacja.pl>
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
В списке pgsql-general по дате отправления: