From: | Andreas Joseph Krogh <andreak(at)officenet(dot)no> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: to_tsquery and to_tsvector .. problem with Y |
Date: | 2012-12-10 22:06:57 |
Message-ID: | OrigoEmail.c2.89edae3c0528738c.13b86d8dd84@prod2.officenet.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
<div>På mandag 10. desember 2012 kl. 21:38:45, skrev akp geek <<a href="mailto:akpgeek(at)gmail(dot)com" target="_blank">akpgeek(at)gmail(dot)com</a>>:</div>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi all -
<div> </div>
<div> We are using to_tsquery and to_tsvector quite a bit. I have noticed that it is not searching for "Y". is there some settings I have to do make sure when search for string that has "Y" to return the correct results?</div>
</blockquote>
<div> </div>
<div>My guess is that the word you'r searching for ends with 'Y' and stemming removes the ending 'Y'. Try using the 'simple' dictionary, like this:</div>
<div> </div>
<div>WHERE searchable_index_col @@ to_tsquery('simple', 'emily');</div>
<div> </div>
<div class="origo-email-signature">--<br>
Andreas Joseph Krogh <andreak(at)officenet(dot)no> mob: +47 909 56 963<br>
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no<br>
Public key: http://home.officenet.no/~andreak/public_key.asc</div>
<div> </div>
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 1.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Burkoff | 2012-12-10 22:38:51 | execution plan is wrong, or the query ? |
Previous Message | Sergey Konoplev | 2012-12-10 22:04:47 | Re: to_tsquery and to_tsvector .. problem with Y |