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 1prxoX-0004Pc-6a for pgsql-docs@arkaria.postgresql.org; Thu, 27 Apr 2023 09:21:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1prxoW-0005sH-2i for pgsql-docs@arkaria.postgresql.org; Thu, 27 Apr 2023 09:21:20 +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 1prxoV-0005s7-OH for pgsql-docs@lists.postgresql.org; Thu, 27 Apr 2023 09:21:19 +0000 Received: from mail-ej1-x632.google.com ([2a00:1450:4864:20::632]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1prxoS-005Lfk-LC for pgsql-docs@lists.postgresql.org; Thu, 27 Apr 2023 09:21:19 +0000 Received: by mail-ej1-x632.google.com with SMTP id a640c23a62f3a-94a342f7c4cso1524718766b.0 for ; Thu, 27 Apr 2023 02:21:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1682587275; x=1685179275; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=W3FJew52/pV6VeM+ENt+FkGKOttgMdbP75iD0n5ehHk=; b=x/I2i0wz82ug47zMvaTU6Fi7+3A3i+W66BO8Cl/jlt1Y8+/mXky9StvmSeBY1hstt3 7t9ZAi3lLCCSAo5no5+EryDsSgSzLda3oQw3fKThaSMsHqJ3CX8XnH1cQD4attrwDmQ/ umzkOc+WFlXUaX5EywvtJAPeaHG6DZ8IS9Qj9/w5bGx7KxKCacqWA7vpK6Ilncu8jKwi 9qeJ4ARJN2w8vW9Kcm7zcSRCO8ryt6pWfRp5EVx5Xqz20VSjnWjex60BNQmao7L66cWW wCkHNwapGudL6NEu8I0tiaLU7+58JL07oEodSVZUjqWzLBUZOw7Asrp9urHtHAna6Ikj ITbA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682587275; x=1685179275; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=W3FJew52/pV6VeM+ENt+FkGKOttgMdbP75iD0n5ehHk=; b=OmdO6T9zMDZ1WXPAJsqSRTf4pm83GRHnn7EWFKv5+61TBImg0Vr8sJSk5nrnwImcd4 qMO5lsaFJDU291MLqzJL2R33+7uFgOAkhOePwpJTq6/w1TKUWZF4H6RkMPmwtflekrcL K4JCYo5H+pSjypjw7nqIuGl/LL46yFSjZHUSSQLi7qMeah/DTgZCVuHTosPfv1xb2rjV lwzHA4/DLXDLDI6W4AUEI00BLORl9sfMaazVLBCNdD1PWXhvhZ6pRTGLLMqXzHlgbbuo WsPxMsxu80yg36fhUYUn6uGyRxtSnlEMePXdJvCrDqYvfwbc4DmE7mkLR919Vy/c6rQs jXCg== X-Gm-Message-State: AC+VfDyN+rqRCKKTuLxbU35sVaEKSGObxPl/LZ/na8L/1Z5LIDvdcQas iTqkL73MkV/xVfelA2cF48Lg96cpybi7OKF4Ufy1fg== X-Google-Smtp-Source: ACHHUZ5GsDqOWKPOjaodUbHTS3gLLczfFxbEjKIbc0uWfLm8MmbSPFIS+iNglA8AQiAI3Fl+bI2r+Q== X-Received: by 2002:a17:906:7950:b0:94f:5847:8ac with SMTP id l16-20020a170906795000b0094f584708acmr1241826ejo.51.1682587275335; Thu, 27 Apr 2023 02:21:15 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:387b:5a4:e99:4794:568d]) by smtp.gmail.com with ESMTPSA id f20-20020a056402069400b00504ecfea8b2sm7711548edy.85.2023.04.27.02.21.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 27 Apr 2023 02:21:15 -0700 (PDT) Message-ID: <40d1ad5294b3b167511b50cf4297eb1b695cd0e6.camel@cybertec.at> Subject: Re: Perhaps an issue on the collation page? From: Laurenz Albe To: jonathan.brune@feisystems.com, pgsql-docs@lists.postgresql.org Date: Thu, 27 Apr 2023 11:21:14 +0200 In-Reply-To: <168254401685.3414353.18185734483713133394@wrigleys.postgresql.org> References: <168254401685.3414353.18185734483713133394@wrigleys.postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-04-26 at 21:20 +0000, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/15/collation.html >=20 > This page states: >=20 > =C2=A0 Observe how in the traditional ICU locale naming system, the root = locale > is selected by an empty string. >=20 > =C2=A0 CREATE COLLATION latinlast (provider =3D icu, locale =3D > 'en-u-kr-grek-latn'); > =C2=A0 CREATE COLLATION latinlast (provider =3D icu, locale =3D > 'en@colReorder=3Dgrek-latn'); >=20 > Neither of the locales are empty strings. The sentence with the "empty string" refers to the example that was before: CREATE COLLATION "und-u-co-emoji-x-icu" (provider =3D icu, locale =3D '@c= ollation=3Demoji'); There is nothing, that is an ampty string, before the "@". Yours, Laurenz Albe