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?
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
