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

From: Dima Tkach <dmitry(at)openratings(dot)com>
To: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 'like' refuses to use an index???
Date: 2003-12-30 23:20:43
Message-ID: 3FF2084B.40108@openratings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-30 23:37:11 Re: 'like' refuses to use an index???
Previous Message Dima Tkach 2003-12-30 22:33:31 Re: 'like' refuses to use an index???