Re: FTS

I’m sorry. Outlook sucks! It doesn’t let me bottom-post.

From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of David Johnston
Sent: Monday, May 05, 2014 11:15 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: Fwd: [NOVICE] FTS

Please reply to the list. Also, it is proper etiquette on this list to bottom-post - just like my original reply.

Original response below.

---------- Forwarded message ----------
From: David Johnston <david(dot)g(dot)johnston(at)gmail(dot)com<mailto:david(dot)g(dot)johnston(at)gmail(dot)com>>
Date: Mon, May 5, 2014 at 11:12 AM
Subject: Re: [NOVICE] FTS
To: Jonatan Malaver <jon(dot)malaver(at)shrewsburyma(dot)gov<mailto:jon(dot)malaver(at)shrewsburyma(dot)gov>>

"kva" thoughs the FTS query off. If I remove kva then it works. I'm looking for suggestions. Should I look for those keywords on the search string and remove them? Or is there a way to make postgres ignore it?

​Create a custom dictionary configuration that defines the abbreviations as "stop words" ​and use it to parse the input query.

http://www.postgresql.org/docs/9.3/interactive/textsearch-controls.html
12.3.2. Parsing Queries
to_tsquery([ config regconfig, ] querytext text) returns tsquery

The documentation is hopefully sufficiently helpful for describing how to create a custom configuration and make use of it.

David J.