Re: case-insensitive database

Thank you, that was the answer I was look for.

"Stephan Szabo" <sszabo@megazone.bigpanda.com> wrote in message
news:20030914172223.W53960@megazone.bigpanda.com...
>
> On Sat, 13 Sep 2003, Relaxin wrote:
>
> > No, I mean the data.
> >
> > select * from stocks where symbol = 'AADBX'
> > and
> > select * from stocks where symbol = 'aadbx'
> >
> > would bring up the same result set.
>
> Potentially on some systems it'd be possible to
> generate a case insensitive collation as part of a locale
> and then use such for LC_COLLATE on initdb which would make all
> comparisons of text fields case insensitive.  That wouldn't
> let you choose some case sensitive and case insensitive
> right now (until we supported different collations within
> one database).  Others have already given most of the normal
> query change ways already I believe (ilike, using upper or
> lower, etc).
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>