[rt-users] EXTERNAL: Re: RT Include substrings with Full-Text Indexing (PostgreSQL)

[Thomas Sibley]

On 07/26/2012 12:26 PM, Betz, Gregory wrote:
> It looks as though the content within ticket is indexed based off of
> whitespaces into the attachments table.

It's not necessarily just whitespace, but it's however Pg internally
tokenizes the text.  substring matching on tokens is a hard problem to
get right without bogging down to the same problems as LIKE.

If you search around there's a lot of discussion about this, as Ken
suggests.