Re: case-insensitive database

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

"Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com> wrote in message
news:20030914172223(dot)W53960(at)megazone(dot)bigpanda(dot)com(dot)(dot)(dot)
>
> 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>