Re: to_tsquery and to_tsvector .. problem with Y
Andreas Joseph Krogh <andreak@officenet.no>
From: Andreas Joseph Krogh <andreak@officenet.no>
To: pgsql-general@postgresql.org
Date: 2012-12-10T22:06:57Z
Lists: pgsql-general
Attachments
- (unnamed) (text/html)
<div>På mandag 10. desember 2012 kl. 21:38:45, skrev akp geek <<a href="mailto:akpgeek@gmail.com" target="_blank">akpgeek@gmail.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@officenet.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>