case-insensitive like operator

Поиск
Список
Период
Сортировка
Hello All,

I have a following problem:

We have ported MS Acess database to PostgreSQL. Everything ok, but our
user are used to search data in tables using filters, and Access does
case insensitive search, but when working with Postgres database it
converts filters into queries with 'like' operator. So is there any
way to make 'like' operator case insensitive? Or maybe somebody has
the same problems and knows the solution?

Best regards,
 Yury                          mailto:yura@vpcit.ru



В списке pgsql-general по дате отправления:

Предыдущее
От: Marcin Mazurek - Multinet SA - Poznan
Дата:
Сообщение: Re: [GENERAL] query with LIKE
Следующее
От: Martin Schulze
Дата:
Сообщение: Re: case-insensitive like operator