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: [email protected] [mailto:[email protected]] Sent: Thursday, July 26, 2012 3:06 PM To: Betz, Gregory Cc: [email protected] 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
