Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppuY9-0001EU-MT for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 17:27:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppuY8-0002pS-D0 for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 17:27:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppuY8-0002pI-0J for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 17:27:56 +0000 Received: from mail-pl1-x62d.google.com ([2607:f8b0:4864:20::62d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ppuY5-004HHy-25 for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 17:27:55 +0000 Received: by mail-pl1-x62d.google.com with SMTP id d9443c01a7336-1a686260adcso26977565ad.0 for ; Fri, 21 Apr 2023 10:27:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20221208.gappssmtp.com; s=20221208; t=1682098070; x=1684690070; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=aIkpkUFRbELrQdB2Xz9NxfjuShkhC3tfn+baOZ6tSQk=; b=GT8oKplkUaVJIEuj6Rcrs/hXbW1X+zf8g1vmf5+8ZKUJurl1WxBx2UVrKXtpKX+you vCHeiPpkf/ds/VtfPpOON6vld8fZNNzD/cGV1vmk7f8fGWGGu7DkV2ZYJjpQbZPlWgoV BvM12ygOdlvEaAoi9iK9t5CzkPXaIFGi6QJfMCZPwcs6KpMuWDKglTRhO2+IV9jLtta5 XnxP0BSz3lBxE9EMuP+jt/lqz/VJwa576m6pJhZSk84xjaNKipkCvaVAFTyQ8mX/Nes9 3KyWvCVbfK6NzLGNe8k3FoTSJRDHGQc1YYuCrQw/0SmqyZNS3JcMDo2X5Dcvq7a8nH/s C+Kg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682098070; x=1684690070; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=aIkpkUFRbELrQdB2Xz9NxfjuShkhC3tfn+baOZ6tSQk=; b=KlxxS4l2iGlrsgrSDgioSioK4dzZpvDkEPP08zycrG+cVPySEiDMgHQrr8nI1sRpOn v4BoOP9SpYYnNKduD5zirN0/bUUw28X/6jDuNiO+jXRN9Mw5pByR7GRiTSLyEc2ab0u4 Wud0tHexKoFAjIpHVClXrAjK3gPh0JD9oJokaiFgkcCj2pmrp7yLAbqrtHilamUy7jPv Vub5xRcZ54EMHSQE5LULWBAV1KS54sikISa5285n4GxE13mgyCB28wMeuxHxnBjvPx6J L0gTgyTVw8BUZGduelMUwwNgLWmDY7+dTknpEgrz9xaj/rUe2YaB5tNosNTBuOuxtnts 7IbA== X-Gm-Message-State: AAQBX9eTMalGbZxdPfA2QxfIDhPS7cXhiXkslCoigh2pwzjPXkoPglKU nyU6mk7CRkiYSneP5uxscHBrSA== X-Google-Smtp-Source: AKy350blJVSw0UU3kR5s0jV/iKKKZRXdf+3+brslTP2kU1M917F8/oSbIOK/QAaWI6Ne4DKQID2upQ== X-Received: by 2002:a17:902:e882:b0:1a1:c8b3:3fe1 with SMTP id w2-20020a170902e88200b001a1c8b33fe1mr7622088plg.31.1682098070533; Fri, 21 Apr 2023 10:27:50 -0700 (PDT) Received: from jeff-laptop.lan (c-73-170-46-202.hsd1.ca.comcast.net. [73.170.46.202]) by smtp.gmail.com with ESMTPSA id a13-20020a1709027d8d00b001a647709860sm2987868plm.157.2023.04.21.10.27.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 21 Apr 2023 10:27:50 -0700 (PDT) Message-ID: <5db89a9f765085f042e1d0ab52a88720f562ee72.camel@j-davis.com> Subject: Re: Order changes in PG16 since ICU introduction From: Jeff Davis To: Sandro Santilli , Tom Lane Cc: Regina Obe , pgsql-hackers@lists.postgresql.org Date: Fri, 21 Apr 2023 10:27:49 -0700 In-Reply-To: References: <000b01d97465$c34bbd60$49e33820$@pcorp.us> <3353947.1682092131@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2023-04-21 at 19:09 +0200, Sandro Santilli wrote: > =C2=A0 =3D# select version(); > =C2=A0 PostgreSQL 16devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu > 11.3.0-1ubuntu1~22.04) 11.3.0, 64-bit > =C2=A0 =3D# show lc_collate; > =C2=A0 C > =C2=A0 =3D# select '+' < '-'; > =C2=A0 f What is the result of: select datlocprovider, datcollate, daticulocale from pg_database where datname=3Dcurrent_database(); > =C2=A0 =3D# select '+' < '-' collate "C"; > =C2=A0 t Regards, Jeff Davis