Re: [BUGS] BUG #5135: sorting order

2009-10-22 Thread Tom Lane
"Savita" 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. reg

[BUGS] BUG #5135: sorting order

2009-10-22 Thread Savita
The following bug has been logged online: Bug reference: 5135 Logged by: Savita Email address: savita.ha...@gmail.com PostgreSQL version: 8.3.5 Operating system: AIX Description:sorting order Details: Hi I have 8.3.5 installed. The sorting order in potsgres would b