| From: | Marcin Mazurek - Multinet SA - Poznan <m(dot)mazurek(at)multinet(dot)pl> |
|---|---|
| To: | |
| Cc: | pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: [GENERAL] case-insensitive like operator |
| Date: | 2000-01-12 11:28:51 |
| Message-ID: | Pine.BSF.4.21.0001121228080.98162-100000@arka.poznan.mtl.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, 15 Jan 2000, yura wrote:
> 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?
take a look at ~= and etc. operators, everything you need is there.
mazek
Marcin Mazurek
--
administrator
MULTINET SA o/Poznan
http://www.multinet.pl/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Warnock | 2000-01-12 11:32:11 | Re: [GENERAL] How do you live without OUTER joins? |
| Previous Message | Adriaan Joubert | 2000-01-12 11:24:53 | Re: [GENERAL] case-insensitive like operator |