Re: case-insensitive database

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).