3 ms·
Anyone experienced with postgres full text search? I want to get something simple setup but couldn't get it to work. I want to match substrings like "/r/chatg
by paradite 2y ago
Anyone experienced with postgres full text search?
I want to get something simple setup but couldn't get it to work.
I want to match substrings like "/r/chatgpt" (sub reddits) in url links, but couldn't get it to match.
Tried a few types of queries like phrase, plain, default, simple, english. All have some weird issues, either not matching special characters, or not matching substrings (partial match). Also I'm somewhat limited on the syntax side by what can be done with drizzle ORM.
- jumping_frog 2y ago> I want to match substrings like "/r/chatgpt" (sub reddits) in url links, but couldn't get it to match. This likely means tokenization striping out special characters. Try ngram search methods. They should work out of box.