På mandag 10. desember 2012 kl. 21:38:45, skrev akp geek <akpgeek@xxxxxxxxx>:
Hi all -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?
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:
WHERE searchable_index_col @@ to_tsquery('simple', 'emily');
--
Andreas Joseph Krogh <andreak@xxxxxxxxxxxx> mob: +47 909 56 963
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
Public key: http://home.officenet.no/~andreak/public_key.asc
Andreas Joseph Krogh <andreak@xxxxxxxxxxxx> mob: +47 909 56 963
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
Public key: http://home.officenet.no/~andreak/public_key.asc
