Postgres has a load of text search operators. The most powerful is ~* whcih gives you a case insensitive regular expression search. Adriaan
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных