- 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