Re: 'like' refuses to use an index???

Поиск
Список
Период
Сортировка
От Dima Tkach
Тема Re: 'like' refuses to use an index???
Дата
Msg-id 3FF2084B.40108@openratings.com
обсуждение исходный текст
Ответ на Re: 'like' refuses to use an index???  ("Keith C. Perry" <netadmin@vcsn.com>)
Список pgsql-general
Keith C. Perry wrote:

>Ahhh, so it is!!  So let me ask you this.  In order to build an index that would
>be able to handle something like "lastname like '%erry'", would you need that
>full text search patch in contrib (tsearch?) or could you do it with an index on
>a function?
>
>
I suppose, if this is all you need, you could just write a function,
that returns it input reversed, and then index by that function...





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

Предыдущее
От: "Keith C. Perry"
Дата:
Сообщение: Re: 'like' refuses to use an index???
Следующее
От: "Keith C. Perry"
Дата:
Сообщение: Re: 'like' refuses to use an index???