Re: case insensitive sorting & searching in oracle 10g - Mailing list pgsql-general

    create a functional index on lower case value of your column.
    ORDER BY lower case value of your column.


> in oracle 10g, you can issue:
>
>   ALTER SESSION SET NLS_COMP = ansi;
>   ALTER SESSION SET NLS_SORT = binary_ci;
>
> do you think this is an elegant solution for case insensitive sorting &
> searching? is there interest in seeing this in postgres?
>