Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?

Поиск
Список
Период
Сортировка
От Ryan Murphy
Тема Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?
Дата
Msg-id CAHeEsBf3aDq9YZ_KUzjhtRpfNWyaaEVqO8dNza63-Ni61QdMOg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения


I'm not sure why we've never got round to providing such a thing
in core ... probably lack of consensus on what to name the reverse
operator.  You'd need to support regex cases as well, so there's
more than one operator name to come up with.

Interesting! It seems like one "simple" possiblity would be to allow ANY() to be on either side...or would that muck up the Grammar too badly or have weird edge cases where it doesn't make sense?
 

                        regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?