Re: interesting finding on order by behaviour

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