Re: Very puzzling sort behavior

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.