Re: 'like' refuses to use an index??? - Mailing list pgsql-general

From Dima Tkach
Subject Re: 'like' refuses to use an index???
Date
Msg-id 3FF2084B.40108@openratings.com
Whole thread Raw
In response to Re: 'like' refuses to use an index???  ("Keith C. Perry" <netadmin@vcsn.com>)
List 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 by date:

Previous
From: "Keith C. Perry"
Date:
Subject: Re: 'like' refuses to use an index???
Next
From: "Keith C. Perry"
Date:
Subject: Re: 'like' refuses to use an index???