I'm using pg_search to full_text_search my customer d/b on name and email address. How do I get a match if I search on the domain part of the email address? e.g. hotmail, returns all customers with a hotmail address.
The steps I've taken so far include using trigram search and adding the psql extension for trigram search. The comment in this article, PG full text search on rails using pg_search gem for substring indicates I need to build a text search dictionary. Anyone know how to do that to split up the email address?
Wouldn't you just be able to search "hotmail" on the email string? pg_search returns results that match a sub-string, so the regular setup will work just fine.