Re: case-insensitive database

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: Relaxin <noname(at)spam(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: case-insensitive database
Date: 2003-09-14 20:06:14
Message-ID: 3F64CA36.5010202@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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' );

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Relaxin 2003-09-14 20:37:33 Re: case-insensitive database
Previous Message Christopher Browne 2003-09-14 19:17:54 Re: need for in-place upgrades (was Re: State of