Inconsistency with LIKE and SIMILAR TO

Поиск
Список
Период
Сортировка
Искать
От
Rosiński Krzysztof 2 - Detal TP
Тема
Inconsistency with LIKE and SIMILAR TO
Дата
Msg-id
49857FC121242345B2EFF3AAE4DA1B8E013AD608@OPEXCN10.tp.gk.corp.tepenet
Список
Дерево обсуждения
Inconsistency with LIKE and SIMILAR TO Rosiński Krzysztof 2 - Detal TP<Krzysztof.Rosinski2@telekomunikacja.pl>
Re: Inconsistency with LIKE and SIMILAR TO Tom Lane <tgl@sss.pgh.pa.us>
Re: Inconsistency with LIKE and SIMILAR TO Thom Brown <thombrown@gmail.com>
Re: Inconsistency with LIKE and SIMILAR TO Bruce Momjian <bruce@momjian.us>
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
В списке pgsql-general по дате отправления
От: Bruce Momjian
Дата:
От: Thom Brown
Дата:
FAQ