From: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Very puzzling sort behavior |
Date: | 2015-09-10 19:55:34 |
Message-ID: | CAD3a31XPeZ8noMkx6XkfuCsBJiPxzas=vyfC9SW2NxTxTOcg6A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alright never mind, I guess I see what's going on. Thanks!
Ken
On Thu, Sep 10, 2015 at 12:51 PM, Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> wrote:
>
>
> On Thu, Sep 10, 2015 at 12:47 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com> writes:
>> > On Thu, Sep 10, 2015 at 12:35 PM, Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
>> wrote:
>> >> Any thoughts about what's going on, what to do about it, or what
>> obvious point I missing? Thanks in advance!
>>
>> > This is the expected behavior.
>>
>> If you don't like it, sort in C locale ...
>>
>> regards, tom lane
>>
>
> OK, can one of you help me out in understanding this? I would have
> thought that given "CLARK," and "CLARKE" that the comma would get compared
> against the E and come first. End of story, before we even get to anything
> farther in the string. What am I missing?
>
> --
> AGENCY Software
> A Free Software data system
> By and for non-profits
> *http://agency-software.org/ <http://agency-software.org/>*
> *https://agency-software.org/demo/client
> <https://agency-software.org/demo/client>*
> ken(dot)tanzer(at)agency-software(dot)org
> (253) 245-3801
>
> Subscribe to the mailing list
> <agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
> learn more about AGENCY or
> follow the discussion.
>
--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://agency-software.org/demo/client
<https://agency-software.org/demo/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801
Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2015-09-10 19:56:24 | Re: Very puzzling sort behavior |
Previous Message | Ken Tanzer | 2015-09-10 19:51:50 | Re: Very puzzling sort behavior |