- 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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
