case-insensitive like operator - Mailing list pgsql-general

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 by date:

Previous
From: Marcin Mazurek - Multinet SA - Poznan
Date:
Subject: Re: [GENERAL] query with LIKE
Next
From: Martin Schulze
Date:
Subject: Re: case-insensitive like operator