Re: case-insensitive database - Mailing list pgsql-general

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' );