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

Betz, Gregory gregory.betz at thesiorg.com
Thu Jul 26 15:26:32 EDT 2012

Hey Ken,

So right know everything is indexed and searching works correctly except that I cannot search on a substring.

For example, 

I have a ticket with the following contained within.

I search for "google.com"...
No results are returned.

I search  for "https://encrypted.google.com/search?q=rt" ...
The ticket with the content is returned.
It looks as though the content within ticket is indexed based off of whitespaces into the attachments table.


-----Original Message-----
From: ktm at rice.edu [mailto:ktm at rice.edu]
Sent: Thursday, July 26, 2012 3:06 PM
To: Betz, Gregory
Cc: rt-users at lists.bestpractical.com
Subject: EXTERNAL: Re: [rt-users] RT Include substrings with Full-Text Indexing (PostgreSQL)

On Thu, Jul 26, 2012 at 06:59:49PM +0000, Betz, Gregory wrote:
> Hello all,
> Is there any way to setup full-text indexing (with PostgreSQL) to index substrings?
> For example, I want to be able to search on part of a string but it 
> currently fails because it is not delimited by spaces
> In ticket:
> https://encrypted.google.com/search?q=rt
> Search query:
> google.com
> Results:
> No results
> Using RT 4.0.5
> Thanks,
> Greg

Hi Greg,

What exactly do you mean? Could you give an explicit example, please.


More information about the rt-users mailing list