Re: Case insensitive indexing in posgtres?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Case insensitive indexing in posgtres?
Дата
Msg-id 20050909105355.GA30738@svana.org
обсуждение исходный текст
Ответ на Case insensitive indexing in posgtres?  (sandeep satpal <sandeep@it.iitb.ac.in>)
Список 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 по дате отправления:

Предыдущее
От: sandeep satpal
Дата:
Сообщение: Case insensitive indexing in posgtres?
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: Alternative variable length structure