pg_search
pg_search copied to clipboard
How to do exact matches?
The any word match works great, even though I prefer comma to separate words.
However, how can I search by record containing an exact phrase, for example if I have 2 records: a) bio: I am CEO b) bio: I am CFO
When I search with a query like this: "am CFO" to return only 1 result, not both. This is a very important feature so probably I'm just missing it. Of course, with any-word option enabled, without any_word option it gives this result, but I can't search by multiple words then.
this is a great question.. trying to figure out the same issue? stumped
I have the same issue, not able to search for phrases...
This would be really helpful too. Even allowing a "raw" tsquery
mode would be very helpful, so that we can just put in to_tsquery('english', 'mister <-> robot'))
.
I whipped up a PR for this as a followed_by
option. Let me know what you think. #417