How is sorting work?

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.

Responses

Browse pgsql-general by date

  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