Re: Docker image of 11~beta2-2 orders strings case-insensitively

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Yahor Yuzefovich <yahor(at)cockroachlabs(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Docker image of 11~beta2-2 orders strings case-insensitively
Date: 2018-08-06 20:34:52
Message-ID: CAKFQuwZ3dWjJhXugqrxucvMajjDYdJEjJ5DWqXYTr4qJDKk87w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Aug 6, 2018 at 12:30 PM, Yahor Yuzefovich <yahor(at)cockroachlabs(dot)com>
wrote:

> I might be missing something, but it looks to me that I have regular
> collation. Sorry, I don't have any experience with this.
>
The locale en_US.utf8 has the behavior you are observing. You seem to be
familiar with the generic "C" locale which has the sorting behavior you are
expecting.

https://www.postgresql.org/docs/10/static/charset.html
David J.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2018-08-06 20:37:22 Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676 when max_parallel_maintenance_workers > 0
Previous Message Peter Geoghegan 2018-08-06 20:31:16 Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676 when max_parallel_maintenance_workers > 0