| From: | Martin Schulze <joey(at)finlandia(dot)Infodrom(dot)North(dot)DE> |
|---|---|
| To: | yura <yura(at)vpcit(dot)ru> |
| Cc: | pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: case-insensitive like operator |
| Date: | 2000-01-12 11:11:40 |
| Message-ID: | 20000112121140.E19482@finlandia.infodrom.north.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
yura wrote:
> 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?
Use *~ (or ~*, I always mistype it).
Regards,
Joey
--
The MS-DOS filesystem is nice for removable media. -- H. Peter Anvin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adriaan Joubert | 2000-01-12 11:24:53 | Re: [GENERAL] case-insensitive like operator |
| Previous Message | Marcin Mazurek - Multinet SA - Poznan | 2000-01-12 10:37:02 | Re: [GENERAL] query with LIKE |