~* OR LIKE?

Поиск
Список
Период
Сортировка
Искать
От
Matt Friedman
Тема
~* OR LIKE?
Дата
Msg-id
00bc01c0b3e7$3bcf6a00$03284d18@mattq3h8budilr
Список
Дерево обсуждения
~* OR LIKE? "Matt Friedman" <matt@daart.ca>
Re: ~* OR LIKE? Tom Lane <tgl@sss.pgh.pa.us>
I have a query that I could run a number of ways:
Like this:

  index_word.word ~*'radio.*'
  OR
  index_word.word ~*'spry.*'

Or I could use LIKE and the "%" comparison

If I toss out the need for comparisions I could just use: IN
('radio','spry')

What's the relative performance for:  "IN" "LIKE" or "~*"? I'm trying to
decide if the performance loss of doing extra string compares is worth
getting slighly more relevant results.

Matt Friedman




В списке pgsql-general по дате отправления
От: will trillich
Дата:
От: Doug McNaught
Дата:
FAQ