Re: interesting finding on order by behaviour

From: Scott Ribe <scott_ribe(at)elevated-dev(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 18:20:09
Message-ID: FBFD1FED-A681-4060-A439-551F853B8D6C@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jul 22, 2011, at 11:11 AM, Samuel Hwang wrote:

> results
> =====
> SQL Server 2008 R2 (with case insensitive data, the ordering follows
> ASCII order)
>
> f1
> ---
> AbC
> abc
> ABc
> cde
> CdE

Well, if it's case insensitive, then AbC & abc & ABc are all equal, so any order for those 3 would be correct...

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

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