Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4bAZ-005ZHD-Nf for pgsql-docs@arkaria.postgresql.org; Wed, 08 May 2024 06:52:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s4bAX-007BNN-0K for pgsql-docs@arkaria.postgresql.org; Wed, 08 May 2024 06:52:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4bAV-007BNF-Sd for pgsql-docs@lists.postgresql.org; Wed, 08 May 2024 06:52:49 +0000 Received: from fout5-smtp.messagingengine.com ([103.168.172.148]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4bAP-001zQr-L5 for pgsql-docs@lists.postgresql.org; Wed, 08 May 2024 06:52:47 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailfout.nyi.internal (Postfix) with ESMTP id C0BE61380FF7; Wed, 8 May 2024 02:52:40 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 08 May 2024 02:52:40 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s=fm2; t=1715151160; x=1715237560; bh=S5mkU+GfhSVq2jIdPfrWKJylGeiitzjY bbzbhz0jzBA=; b=4aAGNmK+I6Ic6HEikB2ue6/1ArnDxXPCcpWMygaCrgT1tLk/ Ads9H1Oomo1prHydhUfJML7aEW+DN4U8rqoQmlSvjKbWt+kuc+k/ECXueJcyTAzI ytkFJBTHX0iio6JGotuuFTrotOTDZvxblkES7ysoFhrLBSidZsFaaRn+jy599bZP l9umrT87P7jXeV9NYlmQw6MfXsG9CpZjXF1VBLJ2y1snMH+Hw0j7azt+KLFRAU0L meTd9TELuFKc5pT1iaSpie0wDl4wFqo/6mZVO2XbXWx9VqXRHyce4S5z0gO7prQt abwGmImQkrXihdjB11ZF5r3lGUT06o1dXc59oA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1715151160; x= 1715237560; bh=S5mkU+GfhSVq2jIdPfrWKJylGeiitzjYbbzbhz0jzBA=; b=E ppAv8aNll8Vt2C3Bl+yCXw1QhwOYzkxX0b4qd3pwqRkt3Cx8koWMEPnZwy6COaOa mUg3HYtwyrpK4eZhyKIPJWT6iMr8OI7PQC3Co333OF5i/mvAKyYPqcTYizzra4l+ ZjjeBUnDWvH+U/El/ZFH3Q6AAXJB4oBOTVyhJio5TalEO/B6CGAynWS8UG+dEO5U 1puz5+AArJdWvHQbBm9t16oGhxezVfDUNr4HR4Uzd/t759r9wyHlPQToWXGYQ0go BTkY0oVIXONGpnjye9LdAwueQtfkz0+QucRVBLc+LAwKiwCK3fT6vx46GWDIW+MA a6NCGijTpYgDt73ZVAshQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrvddvledguddutdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfuffvfhfhvegjtgfgse htjeertddtvdejnecuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvght vghrsegvihhsvghnthhrrghuthdrohhrgheqnecuggftrfgrthhtvghrnhepkeffhfekud fhjeejjefgveefhfffgeffudfgleeikeevffeigfdufeetkeejheevnecuffhomhgrihhn pehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrh grmhepmhgrihhlfhhrohhmpehpvghtvghrsegvihhsvghnthhrrghuthdrohhrgh X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 8 May 2024 02:52:39 -0400 (EDT) Message-ID: Date: Wed, 8 May 2024 08:52:39 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Explanations not clear To: florian.murat.koch@gmail.com, pgsql-docs@lists.postgresql.org References: <171501838010.704.2474442958031349608@wrigleys.postgresql.org> Content-Language: en-US From: Peter Eisentraut Cc: Jeff Davis In-Reply-To: <171501838010.704.2474442958031349608@wrigleys.postgresql.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 06.05.24 19:59, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/collation.html > Description: > > I created a collation specifying the ks-level3 setting and with > deterministic set to false. But when I compare "a_b" to "a-b" with this > collation I get false. According to the table 24.1 it should yield true. > Only after adding ka-shifted this comparison becomes true. The interactions > of the different options are not very clear. I think table 24.1 is somewhat incorrect in the sense that punctuation is only level 4 if you use ka-shifted, otherwise it's level 1. This should perhaps be clarified.