BUG #5135: sorting order
От | Savita |
---|---|
Тема | BUG #5135: sorting order |
Дата | |
Msg-id | 200910221302.n9MD2Bc4098916@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5135: sorting order
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5135 Logged by: Savita Email address: savita.halli@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 be determined by lc_collate. I am not passing the value of lc_collate during initdb. initdb takes the value from locale of the system. I see that with locale C/en_us and en_US.UTF-8, I get different sort for same data in particular column of the table. 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. If yes, please let me know the select query. If not, I would like to confirm if lc_collate value is used only for sorting purpose. If so can I hardcode lc_collate value during initdb? does it affect anyway the localization support of database. Thanks in advance Savita
В списке pgsql-bugs по дате отправления: