Search Postgresql Archives

Re: Very puzzling sort behavior

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Thu, Sep 10, 2015 at 12:47 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Peter Geoghegan <peter.geoghegan86@xxxxxxxxx> writes:
> On Thu, Sep 10, 2015 at 12:35 PM, Ken Tanzer <ken.tanzer@xxxxxxxxx> 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
(253) 245-3801

learn more about AGENCY or
follow the discussion.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux