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 1k2pwf-00048e-Hy for pgsql-docs@arkaria.postgresql.org; Tue, 04 Aug 2020 05:57:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k2pwe-0002qg-Hd for pgsql-docs@arkaria.postgresql.org; Tue, 04 Aug 2020 05:57:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k2pwe-0002qI-BG for pgsql-docs@lists.postgresql.org; Tue, 04 Aug 2020 05:57:04 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k2pwY-0002JD-2z for pgsql-docs@postgresql.org; Tue, 04 Aug 2020 05:57:03 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 87C5F15EF; Tue, 4 Aug 2020 01:56:56 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Tue, 04 Aug 2020 01:56:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=VjVRbiE7pg9SX9MdUpRV/HX88oD Hviac1Eb8byrC164=; b=yhy5BBVlt65+9VWJEQCerBFb5xAcKhCJSuOrksFXp6V K1BAShapQn2j8BLR04ddRL+5IdXwSJW0qsUANajL5bXrRJPnILf4n1V8AWDi6b3y Lxvrqck3TNBpLGlJfdEym4g/MBvZZC9Gz227IVfburVFGpMVyMG7OKQPzfpqOWEX wVqMz1u6zeAM3LhvvkwqT4zTZkHzkpGOmpIPbZEg+i/Y5lqkP55dSYpiy3cBxsqX UxpA0eXikHuRgW+cxecILg/mh9CoNvpYZ6cWPG97Z7S74tNMSiudqUOeSewZArY7 Gh9GtlGGnyQ/L03bwH+FgZdPSRD95Nb/Pu5So6D+0GA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=VjVRbi E7pg9SX9MdUpRV/HX88oDHviac1Eb8byrC164=; b=sSkMrIcGSoUbagqZu4i4q2 jZs/B0cOUcTwcLx0/r9htnyKu8Oxk4ZSNQH5CJsZF+C3zd4fgt9Zjy4NG2RvPYHQ Gi/HX5zXgD9RWR9h+on7rFesEGRNkyfgXhkeOdZ+93E5SIh2eokdOoe/RKJ7zUCl i7ggm6EnRiah6qon0JKKiTpCSfNm7Y2nIamv1TxC+ktAP8CD/+ku9JHPV8whr4RQ 4eoKPKmjdKkrUc0nuMc/+kmK9FCCecl1niO+5z0Q048ESJyXxk2emnO/Q+SRdHWl e4ATHIvaXAAKHD1NWfb9zhu9W0STVCRDnWJKagmqMsflK1plL7Nb24yGnLoVDAww == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduiedrjeehgddutdduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhu ihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrh hnpedvgeduuefhtdeuleettdevjeehheeiveeuieegleetgeeljeelieeuieehgeevhfen ucfkphepudduuddruddtvddrudektddrudekheenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 6837F3060067; Tue, 4 Aug 2020 01:56:54 -0400 (EDT) Date: Tue, 4 Aug 2020 14:56:51 +0900 From: Michael Paquier To: Tom Lane Cc: osdba , pgsql-docs@postgresql.org Subject: Re: Document "59.2. Built-in Operator Classes" have a clerical error? Message-ID: <20200804055651.GC2091@paquier.xyz> References: <38d55061.9604.173b32c60ec.Coremail.mailtch@163.com> <20200803074904.GO3317@paquier.xyz> <2266167.1596453828@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="sHrvAb52M6C8blB9" Content-Disposition: inline In-Reply-To: <2266167.1596453828@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --sHrvAb52M6C8blB9 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Aug 03, 2020 at 07:23:48AM -0400, Tom Lane wrote: > So I don't think it's a clerical error, but certainly showing these > operators this way is none too helpful. Perhaps including the input types > in this table (and its siblings elsewhere) would be a good thing. Ah, thanks. I did not consider the psql shortcut. I agree that including the input types would be a good idea. But just doing that may not be enough IMO as the character policy used on our website for the HTML docs makes that harder to parse. What if we switched the third column to have one line per operator with its input type, and use morerows to show the full set of indexable operators one opclass is associated with? Contrary to wait events, those tables don't change much. I am wondering as well if we should consider mentioning \dAo on all those pages, say at the bottom of each table listing the opclasses.=20 -- Michael --sHrvAb52M6C8blB9 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl8o+KMACgkQnvQgOdby QH0BTw//bIzcW83ysrhq2mXo1JyT4c1/2Yv2Nkyy6vn0R+EllUxrBewvJSJGmbfu kj1VrCjw4wg9QAaGVutn+jaE+sIn0bkhUD8yP5uB4kZJu+WpYuFSdNVnQ+A7T5HA DQje2ue7OOifXwKIY7MrOErHkhcSoVrrX81eHeP8YwrUjOT27qdlqO/fjpXVt8Pw KIwN4aNeu83z6HpFXuQMuxeQL67WFUGDb2YqhhlMFvYHOk57NDfvwtEVLmyZHRMe CW9wdEevsvFnnOSJCdQ7VQMGN90K6w8l09HJxRepc1B4T8F6SzLfiOWVNnZCvNuH xZJST5mj9WnwVu8IQXTp687PNSrEp26iMFmUhFh9EtsC23w5XXuw3mrsbDpLzRGn f6Y2JqzqjkDiYKh//WnD5ontCfMICX+DCv3nvbWh0Vl9GdK/TdNGog56PqRwaPhr 7P0cJQ5dQHp7rd+b+5jHjVlc3gqzxqCKzpmL5UoVE+F3EhJegdP3an6I7ct5M+ip TtVjBhOtmzBTKnyCBhIc/VHoS6IIYM8HnGE3iu5g6nrhyWR/kw/l/uFYeck/K8uF STqulKi7ETRnizI7VfAN8Fq9zEOYeje5PcH9bHD6aU/XT0qHR1iNIja6ejc8s7cR VUJNOW1scG1TqW5zWJyprMGK8UCa3UkeHTS8YqlverpkZBA5t+w= =AAu3 -----END PGP SIGNATURE----- --sHrvAb52M6C8blB9--