| 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: | Whole Thread | Raw Message | 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 |