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 1jPa2j-0002sX-H4 for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Apr 2020 23:05: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 1jPa2g-0004Ft-NF for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Apr 2020 23:05:02 +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 1jPa2g-0004Fl-Gm for pgsql-hackers@lists.postgresql.org; Fri, 17 Apr 2020 23:05:02 +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 1jPa2c-0006dq-KQ for pgsql-hackers@lists.postgresql.org; Fri, 17 Apr 2020 23:05:01 +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 03HN4pCI006100; Fri, 17 Apr 2020 19:04:51 -0400 From: Tom Lane To: "David G. Johnston" cc: Robert Haas , Alvaro Herrera , Steven Pousty , Pavel Stehule , Isaac Morland , Pierre Giraud , PostgreSQL Developers Subject: Re: Poll: are people okay with function/operator table redesign? In-reply-to: References: <20200416230304.GA28390@alvherre.pgsql> <17560.1587083109@sss.pgh.pa.us> <20266.1587148695@sss.pgh.pa.us> Comments: In-reply-to "David G. Johnston" message dated "Fri, 17 Apr 2020 15:30:33 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <6098.1587164691.1@sss.pgh.pa.us> Date: Fri, 17 Apr 2020 19:04:51 -0400 Message-ID: <6099.1587164691@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk "David G. Johnston" writes: > I feel like writing them as: > + (date, integer) -> date > makes more sense as they are mainly sorted on the operator symbol as > opposed to the left operand. Hmm ... we do use that syntax in some fairly-obscure places like ALTER OPERATOR, but I'm afraid that novice users would just be completely befuddled. Maybe the examples would be enough to clarify, but I'm not convinced. Especially not for unary operators, where ALTER OPERATOR would have us write "- (NONE, integer)". regards, tom lane