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 1jQeJJ-0006Wt-SM for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Apr 2020 21:50:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jQeJH-0004ru-U0 for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Apr 2020 21:50:35 +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 1jQeJH-0004rn-N7 for pgsql-hackers@lists.postgresql.org; Mon, 20 Apr 2020 21:50:35 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jQeJ6-0001ur-3i for pgsql-hackers@lists.postgresql.org; Mon, 20 Apr 2020 21:50:35 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id 03KLoJ6M015737; Mon, 20 Apr 2020 17:50:19 -0400 From: Tom Lane To: Alvaro Herrera cc: Victor Yegorov , PostgreSQL Developers Subject: Re: Poll: are people okay with function/operator table redesign? In-reply-to: <20200420213140.GA29785@alvherre.pgsql> References: <20200420213140.GA29785@alvherre.pgsql> Comments: In-reply-to Alvaro Herrera message dated "Mon, 20 Apr 2020 17:31:41 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <15735.1587419419.1@sss.pgh.pa.us> Date: Mon, 20 Apr 2020 17:50:19 -0400 Message-ID: <15736.1587419419@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Alvaro Herrera writes: > There's one with a separate column for the operator, without types, at > the left (the "with names" example at > https://postgr.es/m/14380.1587242177@sss.pgh.pa.us ). That seemed > pretty promising -- not sure why it was discarded. Well, I wouldn't say it was discarded --- but there sure wasn't a groundswell of support. Looking at it again, I'd be inclined not to bother with the morerows trick but just to have an operator name entry in each row. This table is a bit of an outlier anyway, I'm finding --- very few of the operator tables have multiple entries per operator name. regards, tom lane