Postgres Pro
Downloads
Home   >   mailing lists

case-insensitive like operator - Mailing list pgsql-general

From yura
Subject case-insensitive like operator
Date
Msg-id 15659.000115@vpcit.ru
Whole thread Raw
Responses Re: case-insensitive like operator  (Martin Schulze <joey@finlandia.Infodrom.North.DE>)
Re: [GENERAL] case-insensitive like operator  (Marcin Mazurek - Multinet SA - Poznan <m.mazurek@multinet.pl>)
Re: [GENERAL] case-insensitive like operator  (Shadkam Islam <shadkam@wipinfo.soft.net>)
List pgsql-general
Tree view 
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