Postgres Pro
Downloads
Home   >   mailing lists

Re: Index to support LIKE '%suffix' queries - Mailing list pgsql-sql

From Tom Lane
Subject Re: Index to support LIKE '%suffix' queries
Date
Msg-id 11673.1140888147@sss.pgh.pa.us
Whole thread Raw
In response to Index to support LIKE '%suffix' queries  (Florian Weimer <fw@deneb.enyo.de>)
Responses Re: Index to support LIKE '%suffix' queries  (Florian Weimer <fw@deneb.enyo.de>)
List pgsql-sql
Tree view 
Florian Weimer <fw@deneb.enyo.de> writes:
> Is it possible to create an index to support queries of the form
> "column LIKE '%suffix'" (similar to an ordinary index for LIKE
> 'prefix%', which I also need)?

Sounds like what you *really* need is full-text search, not half
measures ... have you looked at tsearch2?
        regards, tom lane

pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Relation 0 does not exist
Next
From: Florian Weimer
Date:
Subject: Re: Index to support LIKE '%suffix' queries