Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating an index-type for LIKE '%value%' - Mailing list pgsql-general

From Tom Lane
Subject Re: Creating an index-type for LIKE '%value%'
Date
Msg-id 28315.1107799764@sss.pgh.pa.us
Whole thread Raw
In response to Creating an index-type for LIKE '%value%'  (CG <cgg007@yahoo.com>)
List pgsql-general
Tree view 
CG <cgg007@yahoo.com> writes:
> Tsearch2 is fantastic, but it works best for fields that contain
> words. I have to sift through alphanumeric identification numbers.

Can't you adjust tsearch2's notion of what is a word?  Sure seems like
that would be easier than reinventing this wheel ...

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Creating an index-type for LIKE '%value%'
Next
From: Yury Don
Date:
Subject: Re: Creating an index-type for LIKE '%value%'