Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

tsvector/tsquery-based full text search producing odd results #242

Closed
toolness opened this issue Nov 24, 2015 · 0 comments
Closed

tsvector/tsquery-based full text search producing odd results #242

toolness opened this issue Nov 24, 2015 · 0 comments

Comments

@toolness
Copy link
Contributor

This has already been fixed in 5573b4a but I wanted to record the rationale behind it here.

Basically, the tsvector/tsquery-based full text search wasn't returning accurate results. If there were two users named Andrew in the system, it would only return one of them; searches for "govlab" only returned 4 people, while many more had "The GovLab" as their organization. Really weird stuff.

The fix uses ILIKE instead, which is almost certainly way less efficient, but will do for now, since we don't have a ton of users.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant