On Tue, 2019-10-15 at 14:51 -0700, raylu wrote: Are we missing something here? Is there either a way to1. generate tsvectors without this special (negative) integer behavior or2. generate tsqueries in a more intelligent way? My company has found the pg_trm extension to be more useful for partial text searches than the full text functions. I don't know specifically how it might help with your hyphens but it would be worth testing. The docs actually suggest using them in conjunction in some cases. |