From: | "Savita" <savita(dot)halli(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5135: sorting order |
Date: | 2009-10-22 13:02:11 |
Message-ID: | 200910221302.n9MD2Bc4098916@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5135
Logged by: Savita
Email address: savita(dot)halli(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2009-10-22 13:43:51 | Re: BUG #5131: The pgsql will lost |
Previous Message | Savita | 2009-10-22 12:55:01 | BUG #5134: initdb fails with return code 1 |