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

[Betz, Gregory]

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.
https://encrypted.google.com/search?q=rt


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.


Thanks,
Greg


-----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.

Cheers,
Ken