Re: interesting finding on order by behaviour

From: Reid Thompson <Reid(dot)Thompson(at)ateb(dot)com>
To: Samuel Hwang <samuel(at)replicon(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: interesting finding on order by behaviour
Date: 2011-07-22 17:36:05
Message-ID: 1311356165.18910.26.camel@raker.ateb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ioana Danes 2011-07-22 18:19:13 Why do I have reading from the swap partition?
Previous Message Samuel Hwang 2011-07-22 17:11:21 interesting finding on order by behaviour