Re: Possible to set postgres in case insensitive mode ?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Possible to set postgres in case insensitive mode ?
Дата
Msg-id dcc563d11001291844x56704a8amdfdba43738c64ebb@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Possible to set postgres in case insensitive mode ?  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Possible to set postgres in case insensitive mode ?  (Moe <mohamed5432154321@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Fri, Jan 29, 2010 at 7:40 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Fri, Jan 29, 2010 at 2:52 PM, Moe <mohamed5432154321@gmail.com> wrote:
>> Is it possible to set postgres in case insensitive mode ?
>>
>> If so, how?
>
> What part, exactly, do you want to be case insensitive?  I assume you
> mean a text / varchar type?  Look for citext, I believe it's a contrib
> module, until 9.0 is out, which will include it natively.

It's here:
http://pgfoundry.org/projects/citext/
But it doesn't work in 8.3 or 8.4, only 8.2 and before.  So either run
that or wait for 9.0 I guess.

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Possible to set postgres in case insensitive mode ?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Possible to set postgres in case insensitive mode ?