case-insensitive like operator

From: yura <yura(at)vpcit(dot)ru>
To: pgsql-general <pgsql-general(at)postgreSQL(dot)org>
Subject: case-insensitive like operator
Date: 2000-01-15 10:49:35
Message-ID: 15659.000115@vpcit.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)vpcit(dot)ru

Responses

Browse pgsql-general by date

  From Date Subject
Next Message yura 2000-01-15 11:28:11 Re[2]: [GENERAL] case-insensitive like operator
Previous Message Oliver Elphick 2000-01-15 10:09:40 Re: [GENERAL] New To List