What I've done in the past in this situation is to create a separate field with the text normalized to whatever the search form is (all lower case, accents stripped, etc.), and then index and search that from the application.

Although I've not tried it, a functional index that did the same thing might work, as long as you were careful in how the queries were written to ensure that it was used.

Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:

Reply via email to