From: | Quang Thoi <Quang_Thoi(at)symantec(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | How is sorting work? |
Date: | 2014-05-31 00:13:57 |
Message-ID: | CFAE6CD5.20826%quang_thoi@symantec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Any one knows how sorting works?
I am using postgresql 9.3 and runs on Linux machines.
I see different sorting order for the same set of return data.
On linux machines, databases are configured the same.
Database have encoding set to 'utf8' and locale='C'
query:
Select host_id, host_name from host_view order by host_id
hos_id (character varying 128)
host_name (character varying 255)
- On one linux machine (locate in U.S) , the query returned following:
host_id host_name
------------ ------------------
"00017486"; "lnx2.xx.yy.com"
"00017486"; "lnx1.xx.yy.com"
- On a different linux machine (locate in India), the query returned following:
host_id host_name
------------ ------------------
"00017486"; "lnx1.xx.yy.com"
"00017486"; "lnx2.xx.yy.com"
Thanks,
Quang.
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Atkins | 2014-05-31 00:20:20 | Re: How is sorting work? |
Previous Message | Adrian Klaver | 2014-05-30 23:44:09 | Re: [HACKERS] unable to build postgres-9.4 in os x 10.9 with python |