On 17.04.2006 21:48, Yudie Pg wrote:
> Is it possible to search partial word as *like '%...%'* in tsearch?
You can create a table with all the unique lexems (see pg_trgm doc on
how to do that) use LIKE %<whatever>% on it, join the matching lexems
with | in your ts_query..
It works ok as long as the count of returned lexems is low.. at some
point a seq scan would be faster again, so you might want to add a
threshold to fall back to that..
--
Regards,
Hannes Dorbath
