Project search would weirdly not actually perform a proper prefix search on slugs, only a prefix search on stemmed ts_vector tokens, which meant statef wouldn't match stateful because stateful gets stemmed to state but statef isn't a prefix of state 🙃
This ditches the web-search syntax since nobody uses it, and adds a simple OR with a prefix search on slug.
Overview
Project search would weirdly not actually perform a proper prefix search on slugs, only a prefix search on stemmed ts_vector tokens, which meant
statef
wouldn't matchstateful
becausestateful
gets stemmed tostate
butstatef
isn't a prefix ofstate
🙃This ditches the web-search syntax since nobody uses it, and adds a simple OR with a prefix search on slug.