"Savita" <savita.halli@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
