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

From Florian Weimer
Subject Index to support LIKE '%suffix' queries
Date
Msg-id 87mzgfh69m.fsf@mid.deneb.enyo.de
Whole thread Raw
Responses Re: Index to support LIKE '%suffix' queries  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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)?

I could define a function which reverts strings (or revert them in the
application) and use a normal B-tree index, but I wonder if there is a
better way.


pgsql-sql by date:

Previous
From: Richard C
Date:
Subject: Re: "Installing" dbLink
Next
From: Stephan Szabo
Date:
Subject: Re: After Trigger assignment to NEW