Skip site navigation (1) Skip section navigation (2)

BUG #5135: sorting order

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: Robert HaasDate: 2009-10-22 13:43:51
Subject: Re: BUG #5131: The pgsql will lost
Previous:From: SavitaDate: 2009-10-22 12:55:01
Subject: BUG #5134: initdb fails with return code 1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group