Re: PostgreSQL and case insensitivity...

Guys,

I'm forwarding this email for your comments.

On January 15, 2006 09:51 am, Charles Phares wrote:
> Hi Robert,
>
> Thanks for taking the time to respond.  Yet another solution which I
> was unaware of.  Must do a closer read of the documentation!  :)
>
> The regexp functions are great for doing equality tests, but they
> will not help with ranged searches or inequality tests.  (i.e.
> greater than or less than)
>
> I really require full-feature support for case insensitivity.
>
> The project page for CITEXT -- http://gborg.postgresql.org/project/
> citext/faq/faq.php?faq_id=105 -- claims that PostgreSQL is unable to
> define the collating sequence of characters.  This seems to be the
> root of my problem.  I know that other database systems -- Sybase &
> Microsoft SQL Server for instance -- use a user selectable server
> wide collation sequence to implement case insensitivity.  This seems
> to be the best solution for portability and compatibility with other
> RDBMS systems.
>
> What would it take to rally the PostgreSQL community to embrace this
> problem?