Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cTy5r-0001uD-PO for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jan 2017 21:48:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cTy5r-000101-CJ for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jan 2017 21:48:35 +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 1cTy4R-0007dk-JD for pgsql-hackers@postgresql.org; Wed, 18 Jan 2017 21:47:07 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cTy4O-0000nY-Ri for pgsql-hackers@postgresql.org; Wed, 18 Jan 2017 21:47:06 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 20B88207C4; Wed, 18 Jan 2017 16:47:04 -0500 (EST) Received: from frontend1 ([10.202.2.160]) by compute5.internal (MEProxy); Wed, 18 Jan 2017 16:47:04 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc:x-sasl-enc; s= smtpout; bh=HKIYbkghIPlEMvi9QnNZi0bOpiA=; b=hPRcqbdZzgjFYLUioqM9 MyqIYXdhKe/nq+E9+vX4XvoV/IopzFPpMt+GpK2R3q4gZyKmddU9hGW9RJKSAyRU fyVCNNNaZHN1trfwKcs1TABV5TLaf5H3e3y2Xt+zyFt8UnF9iyGfA0VyP0D5IO4b DEcyhw5hGzsOicyWIPgWFjw= X-ME-Sender: X-Sasl-enc: YEEBU4RNcJPjjqEG/Sg8zixnNp3GJ2BKLXIimQrKlcuB 1484776023 Received: from intern.anarazel.de (dhcp.229brannan.web-pass.com [208.72.138.66]) by mail.messagingengine.com (Postfix) with ESMTPA id DCE107E876; Wed, 18 Jan 2017 16:47:03 -0500 (EST) Date: Wed, 18 Jan 2017 13:47:02 -0800 From: Andres Freund To: Tom Lane Cc: Robert Haas , "pgsql-hackers@postgresql.org" Subject: Re: Implement targetlist SRFs using ROWS FROM() (was Changed SRF in targetlist handling) Message-ID: <20170118214702.54b2mdbxce5piwv5@alap3.anarazel.de> References: <32021.1484678618@sss.pgh.pa.us> <20170117185346.z55d3jnsaf24yr4m@alap3.anarazel.de> <837.1484680521@sss.pgh.pa.us> <12780.1484747004@sss.pgh.pa.us> <20170118191924.25lfp6rd6y3kw5sa@alap3.anarazel.de> <13690.1484767452@sss.pgh.pa.us> <20170118193420.znochutmnzusd636@alap3.anarazel.de> <15814.1484769612@sss.pgh.pa.us> <460325A6-EF35-4A29-A1A0-EEDC3EDCF750@anarazel.de> <22709.1484771072@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <22709.1484771072@sss.pgh.pa.us> X-Pg-Spam-Score: -2.6 (--) 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 Hi, On 2017-01-18 15:24:32 -0500, Tom Lane wrote: > Andres Freund writes: > > Yea, have something lying around. Let me push it then when I get back from lunch? > > Sure, no sweat. Pushed. Yay! There's one sgml comment you'd added: "Furthermore, nested set-returning functions did not work at all." I'm not quite sure what you're referring to there - it was previously allowed to have one set argument to an SRF: postgres[28758][1]=# SELECT generate_series(1,generate_series(1,5)); ┌─────────────────┐ │ generate_series │ ├─────────────────┤ │ 1 │ │ 1 │ │ 2 │ │ 1 │ │ 2 │ │ 3 │ Am I misunderstanding what you meant? I left it in what I committed, but we probably should clear up the language there. Working on rebasing the cleanup patch now. Interested in reviewing that? Otherwise I think I'll just push the rebased version of what I'd posted before, after making another pass through it. - Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers