Re: order by query wrong result - Mailing list pgsql-admin

From ktm@rice.edu
Subject Re: order by query wrong result
Date
Msg-id 20141119142700.GI10679@aart.rice.edu
Whole thread Raw
In response to Re: order by query wrong result  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: order by query wrong result  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
On Wed, Nov 19, 2014 at 07:13:56AM -0700, Scott Ribe wrote:
> On Nov 19, 2014, at 7:07 AM, jayknowsunix@gmail.com wrote:
> >
> > That doesn't look like an error to me. The upper() function is only converting your name field to upper case and
thenthe "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@elevated-dev.com
> http://www.elevated-dev.com/
> (303) 722-0567 voice

They are based on your locale.

Regards,
Ken


pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: order by query wrong result
Next
From: Scott Ribe
Date:
Subject: Re: order by query wrong result