Case insensitive indexing in posgtres?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Case insensitive indexing in posgtres?

sandeep satpal

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.

I dont want that user should always write lower and uppder during using
it.
I just need information that where exactly in the code of postgres it
compare the values of attribute supplied by user and values of
attribute present in the database.

Thanking you,
sandeep


--
------------------
| Sandeep Satpal |
| M.Tech Student |
| Lab 212 KReSIT |
------------------

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
Reply | Threaded
Open this post in threaded view
|

Re: Case insensitive indexing in posgtres?

Martijn van Oosterhout
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   <[hidden email]>   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.

attachment0 (240 bytes) Download Attachment