Re: Case insensitive selects? - Mailing list pgsql-general

From Anand Raman
Subject Re: Case insensitive selects?
Date
Msg-id 20010215111306.B12359@india-today.com
Whole thread Raw
In response to Re: Case insensitive selects?  ("Adam Lang" <aalang@rutgersinsurance.com>)
Responses Re: Case insensitive selects?  (Michael Fork <mfork@toledolink.com>)
List pgsql-general
Hi
use it if u absolutly need it.. Using a function on a column name
doesnt use the index associated with that column,.. So exercise this
option with some amount of thinking..

Anand
On Wed, Feb 14, 2001 at 11:39:47AM -0500, Adam Lang wrote:
>It is in the list archives several times.
>
>All you need is to use some basic SQL.
>
>select * from mytable where upper('my criteria') = upper(mytable.info);
>
>Adam Lang
>Systems Engineer
>Rutgers Casualty Insurance Company
>http://www.rutgersinsurance.com
>----- Original Message -----
>From: "David Reid" <dreid@jetnet.co.uk>
>To: <pgsql-general@postgresql.org>
>Sent: Wednesday, February 14, 2001 9:58 AM
>Subject: [GENERAL] Case insensitive selects?
>
>
>> Does pgsql support this and how would I do it?
>>
>> david

pgsql-general by date:

Previous
From: Anand Raman
Date:
Subject: Re: Tuple is to big
Next
From: Michael Fork
Date:
Subject: Re: Case insensitive selects?