Re: case insensitive sorting & searching in oracle 10g

- not transparent
- can't automatically make all values fed to SELECT case-converted
- not transparent

Pierre-Frédéric Caillaud wrote:
>
>     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?

--
dave