~* 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 по дате отправления