Re: full text search and ILIKE type clauses. - Mailing list pgsql-general

From Pavel Stehule
Subject Re: full text search and ILIKE type clauses.
Date
Msg-id CAFj8pRAn6nGw6YSHYvCr63V-PsXH=kiX4kxeqRWZenDd2Dix9g@mail.gmail.com
Whole thread Raw
In response to Re: full text search and ILIKE type clauses.  (Tim Uckun <timuckun@gmail.com>)
List pgsql-general
2012/3/12 Tim Uckun <timuckun@gmail.com>:
>> It is my understanding that since the extention citext is available that
>> this gives you what your asking for and at least at this point isn't
>> going to be part of the core.
>>
>
> For me it's more of a workaround than a solution but yes probably good
> enough. Collation is more subtle than case insensitive comparisons but
> for english anyway it should be good enough.

Postgres uses system locales - so theoretically you can write own case
insensitive locale.

Regards

Pavel Stehule

>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: full text search and ILIKE type clauses.
Next
From: John R Pierce
Date:
Subject: Re: Upgrade questions