Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eZhj2-00040G-BP for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Jan 2018 18:37:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eZhj1-0006Tk-Nt for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Jan 2018 18:37:15 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eZhj1-0006TZ-EH for pgsql-hackers@lists.postgresql.org; Thu, 11 Jan 2018 18:37:15 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eZhiz-0002O6-3f for pgsql-hackers@postgresql.org; Thu, 11 Jan 2018 18:37:14 +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 w0BIb5li010984; Thu, 11 Jan 2018 13:37:05 -0500 From: Tom Lane To: Robert Haas cc: Andres Freund , Dmitry Dolgov <9erthalion6@gmail.com>, Michael Paquier , Arthur Zakirov , Oleg Bartunov , Peter Eisentraut , David Steele , PostgreSQL-development Subject: Re: [HACKERS] [PATCH] Generic type subscripting In-reply-to: References: <20171116114016.GA21162@zakirov.localdomain> <20171119151350.GA23853@arthur.localdomain> <8809.1515031526@sss.pgh.pa.us> <20180108232959.s2ipp7tjcvlaixcs@alap3.anarazel.de> <846.1515629363@sss.pgh.pa.us> <10021.1515694533@sss.pgh.pa.us> Comments: In-reply-to Robert Haas message dated "Thu, 11 Jan 2018 13:30:03 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <10982.1515695825.1@sss.pgh.pa.us> Date: Thu, 11 Jan 2018 13:37:05 -0500 Message-ID: <10983.1515695825@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Robert Haas writes: > On Thu, Jan 11, 2018 at 1:15 PM, Tom Lane wrote: >> I think you missed the point. The question is whether the existence of a >> subscripting function means that we need to treat the subscriptable type >> as physically containing the subscript result type. > I don't think I missed the point at all -- this is the exact same set > of issues that arise with respect to functions. Indeed, I gave an > example of a function that needs to be updated if a column of the > input type is altered. In the case of functions, we've decided that > it's not our problem. Right, but in the case of stored arrays, we've decided that it *is* our problem (as indeed it must be, because the user has no tools with which they could fix a representation change for stored data). The question is to what extent that need would propagate to pseudo array types. > In other words, we're vigorously agreeing. I think we're agreed on what should be in the v1 version of the patch. I'm not 100% convinced that the problem won't come up eventually. regards, tom lane