"Savita" <savita.ha...@gmail.com> writes: > I would like to know if there is anyway we can get the same sorting order > irreespective of lc_collate value when doing the select query.
You could do "ORDER BY col USING ~<~", but on the whole it's really better to set LC_COLLATE the way you want. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs