Re: Flag for insentive use of Postgres? - Mailing list pgsql-general

On Wed, Jul 10, 2002 at 02:03:30PM +0200, Andreas Schlegel wrote:
> Hi,
>
> is there a flag to set which determines if queries run successful with a
> case sensitive or case insensitive WHERE clause:
>
> For example: if I have a name1 colum with a value 'Test' I would like to
> search for 'test' and get also this row
> (select * from tTest where name1='test')

If all you want is the values to match without case sensitivity, use
ILIKE.  (The rules are different in different locales, and I don't
even know how ILIKE works for non-C locales.)

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110