Postgres Pro
Downloads
Home   >   mailing lists

Re: interesting finding on order by behaviour - Mailing list pgsql-general

From Reid Thompson
Subject Re: interesting finding on order by behaviour
Date
Msg-id 1311356165.18910.26.camel@raker.ateb.com
Whole thread Raw
In response to interesting finding on order by behaviour  (Samuel Hwang <samuel@replicon.com>)
List pgsql-general
Tree view
On Fri, 2011-07-22 at 10:11 -0700, Samuel Hwang wrote: 
I ran the same tests in SQL Server 2008R2, Oracle10 and PostgreSQL
9.0.4 and found something interesting...
results
=====
SQL Server 2008 R2 (with case insensitive data, the ordering follows
ASCII order)

Oracle 10 (data is case-sensitive, the ordering follows ASCII order)

PostgreSQL 9.0.4 (data is case-sensitive, the ordering is ...
DIFFERENT)

perhaps   http://www.postgresql.org/docs/9.1/static/charset.html  will provide an answer

pgsql-general by date:

Previous
From: Samuel Hwang
Date:
Subject: interesting finding on order by behaviour
Next
From: Scott Ribe
Date:
Subject: Re: interesting finding on order by behaviour