Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cTZEJ-0004Dm-W0 for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Jan 2017 19:15:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cTZEJ-0007Su-CX for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Jan 2017 19:15:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cTZE9-0007Jg-I5 for pgsql-hackers@postgresql.org; Tue, 17 Jan 2017 19:15:29 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cTZE6-0001dd-B2 for pgsql-hackers@postgresql.org; Tue, 17 Jan 2017 19:15:29 +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 v0HJFL0Q000838; Tue, 17 Jan 2017 14:15:21 -0500 From: Tom Lane To: Andres Freund cc: Robert Haas , "pgsql-hackers@postgresql.org" Subject: Re: Implement targetlist SRFs using ROWS FROM() (was Changed SRF in targetlist handling) In-reply-to: <20170117185346.z55d3jnsaf24yr4m@alap3.anarazel.de> References: <20161031160639.nyxoktszi5psl2cc@alap3.anarazel.de> <20170116032952.z2re55hcfhzbkmrm@alap3.anarazel.de> <20170116083316.2izqrxbvmyalazac@alap3.anarazel.de> <21924.1484593998@sss.pgh.pa.us> <29207.1484675540@sss.pgh.pa.us> <20170117180324.dqgz23xaf6wtazb4@alap3.anarazel.de> <30268.1484677082@sss.pgh.pa.us> <32021.1484678618@sss.pgh.pa.us> <20170117185346.z55d3jnsaf24yr4m@alap3.anarazel.de> Comments: In-reply-to Andres Freund message dated "Tue, 17 Jan 2017 10:53:46 -0800" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <836.1484680521.1@sss.pgh.pa.us> Date: Tue, 17 Jan 2017 14:15:21 -0500 Message-ID: <837.1484680521@sss.pgh.pa.us> X-Pg-Spam-Score: -5.1 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Andres Freund writes: > On 2017-01-17 13:43:38 -0500, Tom Lane wrote: >> I'm not convinced that that optimization is worth preserving, but if we >> keep it then ProjectSet isn't le mot juste here, any more than you'd want >> to rename Result to Project without changing its existing >> functionality. > Right. I'd removed that, and re-added it; primarily because the plans > looked more complex without it. After all, you'd thought it worth adding > that hack ;) I'm happy with removing it again too. Well, it seemed reasonable to do that as long as the only cost was ten or so lines in create_projection_plan. But if we're contorting not only the behavior but the very name of the SRF-evaluation plan node type, that's not negligible cost anymore. So now I'm inclined to take it out. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers