Re: case-insensitive database

Hello....
Does anyone understand what is meant by a case-insensitive database.

Are there some collations that can be changed or is there just no way to
have a true case-insensitive Postgresql database?

Thanks

"Dennis Gearon" <gearond(at)fireserve(dot)net> wrote in message
news:3F64CA36(dot)5010202(at)fireserve(dot)net(dot)(dot)(dot)
> 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.
> >
> >
> >
> Look in the manuals, there are SQL functions like:
>
> STRTOLOWER( ); STRTOUPPER() like those in 'C'
>
> Usage:
> -------
> SELECT *
> FROM stocks
> WHERE
> STRTOLOWER( symbol ) = STRTOLOWER( 'AADBX' );
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>