Re: Case insensitive indexing in posgtres? - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Case insensitive indexing in posgtres?
Date
Msg-id 20050909105355.GA30738@svana.org
Whole thread Raw
In response to Case insensitive indexing in posgtres?  (sandeep satpal <sandeep@it.iitb.ac.in>)
List pgsql-hackers
On Fri, Sep 09, 2005 at 04:00:57PM +0530, sandeep satpal wrote:
>
> Dear ,
>
> One of the difference in mysql and postgresql is case insensitiveness.
> I want to midify the code of posgresql so that it can support case
> insensitiveness in indexing and in join operation.

Use citext:

http://gborg.postgresql.org/project/citext/projdisplay.php
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

pgsql-hackers by date:

Previous
From: sandeep satpal
Date:
Subject: Case insensitive indexing in posgtres?
Next
From: Manfred Koizar
Date:
Subject: Re: Alternative variable length structure