Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i6KJi-00070J-CM for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Sep 2019 19:54:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i6KJh-00008p-6J for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Sep 2019 19:54:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i6KJf-0008VM-V5 for pgsql-hackers@lists.postgresql.org; Fri, 06 Sep 2019 19:54:44 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1i6KJc-0000KU-9d for pgsql-hackers@lists.postgresql.org; Fri, 06 Sep 2019 19:54:42 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 7FE034B3; Fri, 6 Sep 2019 15:54:38 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Fri, 06 Sep 2019 15:54:38 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; bh=UohCBiUW6TbMHcj8kNOaGWLsdB5niVXgEZZkxo7GW4Q=; b=SSgTvYoX VugLxZGRsnTGFRqyYvfZL/pOGOYm332/G5EoCiMUU9HqzLgH0NVbr9NBbbVWWlma Zq1+/My0i+Iae8iom/+VB8l+BajnfyE/eaHQcptHA1SC8pZNvX8KClNAj7JanEol vaWjnE/RFyFBaApxqAARR+xDRAWKPI0h6dfpuQTe+hZ6A7Y39xWW6XwtEIHwWlJS iPJuRbPbEQSJI3KJgMz6j0QH/VQPy1r1U+lIOdWOwZOSg4JJTSjat4IF6lVZgDuX vyVT9zb0t/P0FcjHsPcioAuqj3qP6uJZpLYu70LiAMQgIrpg2nagDU+M8d4D4G9b 34F3PBOd1yWDTg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduvddrudejledguddvlecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpeffhffvuffkgggtugfgjggfsehtkeertddtredunecuhfhrohhmpeetlhhv rghrohcujfgvrhhrvghrrgcufhhrohhmucdvnhgusfhurggurhgrnhhtuceorghlvhhhvg hrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgheqnecuffhomhgrihhnpedvnhguqhhurggu rhgrnhhtrdgtohhmnecukfhppeduledtrddvudejrddukeefrddvtddvnecurfgrrhgrmh epmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgnecu vehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from nimloth.alvh.no-ip.org (unknown [190.217.183.202]) by mail.messagingengine.com (Postfix) with ESMTPA id 0DD3ED6005F; Fri, 6 Sep 2019 15:54:37 -0400 (EDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 82A1F1209C5; Fri, 6 Sep 2019 15:54:34 -0400 (-04) Date: Fri, 6 Sep 2019 15:54:34 -0400 From: Alvaro Herrera from 2ndQuadrant To: Tom Lane Cc: Andrew Gierth , pgsql-hackers@lists.postgresql.org Subject: Re: SQL-spec incompatibilities in similar_escape() and related stuff Message-ID: <20190906195434.GA19525@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <32617.1558649424@sss.pgh.pa.us> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-May-23, Tom Lane wrote: > + > + Another nonstandard extension is that following the escape character > + with a letter or digit provides access to the same escape sequences > + defined for POSIX regular expressions, below (see > + , > + , and > + ). > I think the word "same" in this para is more confusing than helpful; also the tables are an integral part of this rather than just an illustration, so they should not be in parenthesis but after only a semicolon or such. So: > + Another nonstandard extension is that following the escape character > + with a letter or digit provides access to the escape sequences > + defined for POSIX regular expressions; see > + , > + , and > + below. I think it would be useful to provide a trivial example that illustrates this in the below; say '\mabc\M' not matching "zabc". All in all, these are pretty trivial points and I would certainly not be mad if it's committed without these changes. Marked ready for committer. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services