| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | igor <linux_211(at)hotmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Disabling case sensitivity |
| Date: | 2002-07-10 13:11:42 |
| Message-ID: | 1026306702.1183.148.camel@linda |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Wed, 2002-07-10 at 00:11, igor wrote:
> I would like to know if there is some way how to disable case
> sensitivity in PostgreSQL server. With some varaiable or some setting
> in configuration file or how?
> So after this would be the same 'Good' and 'GOOD' or 'GoOd' in some
> SELECT from table where username='Good'. I wanna get the same row
> with:
> SELECT from table where username='GoOd';
> Exactly like in MS SQL server.
You can use ILIKE, or search for a match to lower('GoOd') (or upper()).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Meskes | 2002-07-10 13:22:00 | Re: Disabling case sensitivity |
| Previous Message | Stephane Bortzmeyer | 2002-07-10 12:51:19 | Re: [GENERAL] Disabling case sensitivity |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Meskes | 2002-07-10 13:22:00 | Re: Disabling case sensitivity |
| Previous Message | Hannu Krosing | 2002-07-10 13:11:34 | Re: (A) native Windows port |