Re: order by query wrong result

From: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: jayknowsunix(at)gmail(dot)com, Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: order by query wrong result
Date: 2014-11-19 14:27:00
Message-ID: 20141119142700.GI10679@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Nov 19, 2014 at 07:13:56AM -0700, Scott Ribe wrote:
> On Nov 19, 2014, at 7:07 AM, jayknowsunix(at)gmail(dot)com wrote:
> >
> > That doesn't look like an error to me. The upper() function is only converting your name field to upper case and then the "order by" is simply alphabetical based on that, which is what your return values are.
>
> No, they're not--look again.
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> http://www.elevated-dev.com/
> (303) 722-0567 voice

They are based on your locale.

Regards,
Ken

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2014-11-19 14:34:09 Re: order by query wrong result
Previous Message Albe Laurenz 2014-11-19 14:25:40 Re: order by query wrong result