Re: FTS
От | Jonatan Malaver |
---|---|
Тема | Re: FTS |
Дата | |
Msg-id | 58E13A9FA1D4994EB29384A8025A97B21BBF98F5@mbx027-e1-nj-6.exch027.domain.local обсуждение исходный текст |
Ответ на | Fwd: FTS (David Johnston <david.g.johnston@gmail.com>) |
Ответы |
Re: FTS
|
Список | pgsql-novice |
I’m sorry. Outlook sucks! It doesn’t let me bottom-post.
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of David Johnston
Sent: Monday, May 05, 2014 11:15 AM
To: pgsql-novice@postgresql.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.g.johnston@gmail.com>
Date: Mon, May 5, 2014 at 11:12 AM
Subject: Re: [NOVICE] FTS
To: Jonatan Malaver <jon.malaver@shrewsburyma.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.
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.
В списке pgsql-novice по дате отправления: