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 1pcGaE-0006fY-E3 for pgsql-general@arkaria.postgresql.org; Wed, 15 Mar 2023 02:09:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pcGaD-0004Vh-8v for pgsql-general@arkaria.postgresql.org; Wed, 15 Mar 2023 02:09:41 +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 1pcGaC-0004VX-8O for pgsql-general@lists.postgresql.org; Wed, 15 Mar 2023 02:09:40 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcGa8-0003Zr-AS for pgsql-general@lists.postgresql.org; Wed, 15 Mar 2023 02:09:39 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 190035C0A33; Tue, 14 Mar 2023 22:09:35 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Tue, 14 Mar 2023 22:09:35 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm1; t= 1678846175; x=1678932575; bh=gxkJKW6GYSZh40/iwgQ8k7rnZjA12aH7ixl VqOvWDlg=; b=AtmgpyC7Odg4dNhZbxAK/t7QjkGid4tl4Oh6srYfrG4D3IDzbGE OMp80Wa1L1rV7F2c5PVieRPZC6pNfrso2HFdAEDikzQJD8cDQ6NXNmDUrN0yqh1y R3ahgX7N7hpDtVfAOJhFlDu9JlrWwn4YwxH1sRt0WTHSmaEe5mi/ZPS8idbKWgZs P8KTvE3Odv7c8L79QONJhadeA+SaiTSATFvw0BSS8pPJw+meHsm7+2O1wsaUCzG+ hEamEwZtm7LXmStHUVdnwR4HYNDYSKt1zdlphKXatS8yLlbLfmDGgNGwbFU++9kZ q2O5YUnNMLCKtmnZ4gM4D0waW+bVSJ/4/6g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1678846175; x= 1678932575; bh=gxkJKW6GYSZh40/iwgQ8k7rnZjA12aH7ixlVqOvWDlg=; b=R q7bQ+R94Vii4IUfWMOh4pLGiE4MGESdrRvRShA9m/vHI8umss6Ppo/Wr1jxMMiDn 1DXO9rBgDahyLNR4yDMe3eq1AQ20/8vCDeEXX3nmRsov875IucpAc0LONzzIaXwP HijldwoWNxwDw22e26ckjNUOihI1V4E0DRDSKl6fKcdDOPyT/N1yT6yuwNMuEIUC bpVEDsLSPskcJaJj522v4OmWTQlM9/g5WVSf9Ipscf1SVN03+j7Bmys2fLxfQBxu KGoMPu+xy5/pSvuaOmcfPFskPMAM5XQz5+fIq7MoQQodhUbaifW9DbCnlCdmBHVN DRJSUZftoT2NPsM52qZlA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrvddvjedggedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvfhfhjggtgfesthgsredttdefjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeeivdduleeuvdegffekteehgeeiheehhfehhedtkefh geeuheffudeludfgfeelgfenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhi rghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 14 Mar 2023 22:09:34 -0400 (EDT) Message-ID: Date: Tue, 14 Mar 2023 19:09:33 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.8.0 Subject: Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? To: Bryn Llewellyn , pgsql-general list References: <6A73AAEA-7A9F-42C9-A842-88213FA41003@yugabyte.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <6A73AAEA-7A9F-42C9-A842-88213FA41003@yugabyte.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMy8xNC8yMyAxNzo1MCwgQnJ5biBMbGV3ZWxseW4gd3JvdGU6DQo+IFNlY3Rpb24gIjQz LjcuIEN1cnNvcnPigJ0gaW4gdGhlIFBML3BnU1FMIGNoYXB0ZXIgb2YgdGhlIGRvYyAod3d3 LnBvc3RncmVzcWwub3JnL2RvY3MvY3VycmVudC9wbHBnc3FsLWN1cnNvcnMuaHRtbCNQTFBH U1FMLUNVUlNPUi1ERUNMQVJBVElPTlMpIHN0YXJ0cyB3aXRoIHRoaXM6DQo+IA0KPiDCqw0K PiBSYXRoZXIgdGhhbiBleGVjdXRpbmcgYSB3aG9sZSBxdWVyeSBhdCBvbmNlLCBpdCBpcyBw b3NzaWJsZSB0byBzZXQgdXAgYSBjdXJzb3IgdGhhdCBlbmNhcHN1bGF0ZXMgdGhlIHF1ZXJ5 LCBhbmQgdGhlbiByZWFkIHRoZSBxdWVyeSByZXN1bHQgYSBmZXcgcm93cyBhdCBhIHRpbWUu IE9uZSByZWFzb24gZm9yIGRvaW5nIHRoaXMgaXMgdG8gYXZvaWQgbWVtb3J5IG92ZXJydW4g d2hlbiB0aGUgcmVzdWx0IGNvbnRhaW5zIGEgbGFyZ2UgbnVtYmVyIG9mIHJvd3MuIChIb3dl dmVyLCBQTC9wZ1NRTCB1c2VycyBkbyBub3Qgbm9ybWFsbHkgbmVlZCB0byB3b3JyeSBhYm91 dCB0aGF0LCBzaW5jZSBGT1IgbG9vcHMgYXV0b21hdGljYWxseSB1c2UgYSBjdXJzb3IgaW50 ZXJuYWxseSB0byBhdm9pZCBtZW1vcnkgcHJvYmxlbXMuKSBBIG1vcmUgaW50ZXJlc3Rpbmcg dXNhZ2UgaXMgdG8gcmV0dXJuIGEgcmVmZXJlbmNlIHRvIGEgY3Vyc29yIHRoYXQgYSBmdW5j dGlvbiBoYXMgY3JlYXRlZCwgYWxsb3dpbmcgdGhlIGNhbGxlciB0byByZWFkIHRoZSByb3dz LiBUaGlzIHByb3ZpZGVzIGFuIGVmZmljaWVudCB3YXkgdG8gcmV0dXJuIGxhcmdlIHJvdyBz ZXRzIGZyb20gZnVuY3Rpb25zLg0KPiDCuw0KPiANCj4gT24gaXRzIGZhY2UsIGl0IHNlZW1z IHRvIG1ha2Ugc2Vuc2UuIEFuZCBJ4oCZdmUgd3JpdHRlbiBhIGZldyBwcm9vZi1vZi1jb25j ZXB0IHRlc3RzLiBGb3IgZXhhbXBsZSwgSSB3cm90ZSBhIOKAnHNlY3VyaXR5IGRlZmluZXLi gJ0gZnVuY3Rpb24gdGhhdCdzIG93bmVkIGJ5IGEgcm9sZSB0aGF0IGNhbiBzZWxlY3QgZnJv bSB0aGUgcmVsZXZhbnQgdGFibGUocykgdGhhdCByZXR1cm5zIHJlZmN1cnNvci4gQW5kIEkg Y2FsbGVkIGl0IGZyb20gYSBzdWJwcm9ncmFtIHRoYXQncyBvd25lZCBieSBhIHJvbGUgdGhh dCBjYW5ub3Qgc2VsZWN0IGZyb20gdGhlIHJlbGV2YW50IHRhYmxlKHMpIHRvIGxvb3AgdGhy b3VnaCB0aGUgcm93cy4gQnV0IEkgY2FuJ3QgY29udmluY2UgbXlzZWxmIHRoYXQgdGhpcyBk aXZpc2lvbiBvZiBsYWJvciBpcyB1c2VmdWwuIEFuZCBlc3BlY2lhbGx5IEkgY2FuJ3QgY29u dmluY2UgbXlzZWxmIHRoYXQgdGhlICJwaXBlbGluZyIgY2FwYWJpbGl0eSBpcyByZWxldmFu dCBpbiBhIHRocmVlLXRpZXIgYXBwIHdpdGggYSBzdGF0ZWxlc3MgYnJvd3NlciBVSS4gSGVy ZSwgdGhlIHBhcmFkaWdtIGhhcyB0aGUgY2xpZW50LXNpZGUgYXBwIGNoZWNraW5nIG91dCBh IGNvbm5lY3Rpb24gZnJvbSB0aGUgcG9vbCwgZ2VuZXJhdGluZyB0aGUgZW50aXJlIHJlc3Bv bnNlIHRvIHRoZSBlbmQtdXNlcidzIHJlcXVlc3QsIHJlbGVhc2luZyB0aGUgY29ubmVjdGlv biwgYW5kIHNlbmRpbmcgdGhlIHJlc3BvbnNlIGJhY2sgdG8gdGhlIGJyb3dzZXIuIFRoaXMg cGFyYWRpZ20gaXNuJ3QgY29uc2lzdGVudCB3aXRoIGFsbG93aW5nIHRoZSBlbmQgdXNlciB0 byBuYXZpZ2F0ZSBmb3J3YXJkcyBhbmQgYmFja3dhcmRzIGluIGEgc2Nyb2xsYWJsZSBjdXJz b3IgdGhhdCBpcyBzb21laG93IGhlbGQgaW4gaXRzIG9wZW4gc3RhdGUgaW4gaW4gdGhlIHNl dmVyIGJ5IHRoZSB0aGUgbWlkZGxlIHRpZXIgY2xpZW50IG9uIGJlaGFsZiBvZiBhIGJyb3dz ZXIgc2Vzc2lvbiB0aGF0IGNvbWVzIGJhY2sgdGltZSBhbmQgYWdhaW4gdG8gaXRzIGRlZGlj YXRlZCBtaWRkbGUgdGllciBjbGllbnQgYW5kIHRoZW5jZSB5byBpdHMgZGVkaWNhdGVkIGRh dGFiYXNlIHNlcnZlciBzZXNzaW9uLiAoQW55d2F5LCB3aXRob3V0IGFueXRoaW5nIGxpa2Ug T3JhY2xlIFBML1NRTCdzIHBhY2thZ2VzLCB5b3UgaGF2ZSBubyBtZWNoYW5pc20gdG8gaG9s ZCB0aGUgb3BlbmVkIGN1cnNvciB2YXJpYWJsZSBiZXR3ZWVuIHN1Y2Nlc3NpdmUgc2VydmVy IGNhbGxzLikNCg0KSSBndWVzcyB0aGF0IHdvdWxkIGRlcGVuZCBvbiBob3cgeW91IGRlZmlu ZSBhIHNlcnZlciBjYWxsOg0KDQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1 cnJlbnQvcGxwZ3NxbC1jdXJzb3JzLmh0bWwjUExQR1NRTC1DVVJTT1ItVVNJTkcNCg0KIk9u Y2UgYSBjdXJzb3IgaGFzIGJlZW4gb3BlbmVkLCBpdCBjYW4gYmUgbWFuaXB1bGF0ZWQgd2l0 aCB0aGUgDQpzdGF0ZW1lbnRzIGRlc2NyaWJlZCBoZXJlLg0KDQpUaGVzZSBtYW5pcHVsYXRp b25zIG5lZWQgbm90IG9jY3VyIGluIHRoZSBzYW1lIGZ1bmN0aW9uIHRoYXQgb3BlbmVkIHRo ZSANCmN1cnNvciB0byBiZWdpbiB3aXRoLiBZb3UgY2FuIHJldHVybiBhIHJlZmN1cnNvciB2 YWx1ZSBvdXQgb2YgYSBmdW5jdGlvbiANCmFuZCBsZXQgdGhlIGNhbGxlciBvcGVyYXRlIG9u IHRoZSBjdXJzb3IuIChJbnRlcm5hbGx5LCBhIHJlZmN1cnNvciB2YWx1ZSANCmlzIHNpbXBs eSB0aGUgc3RyaW5nIG5hbWUgb2YgYSBzby1jYWxsZWQgcG9ydGFsIGNvbnRhaW5pbmcgdGhl IGFjdGl2ZSANCnF1ZXJ5IGZvciB0aGUgY3Vyc29yLiBUaGlzIG5hbWUgY2FuIGJlIHBhc3Nl ZCBhcm91bmQsIGFzc2lnbmVkIHRvIG90aGVyIA0KcmVmY3Vyc29yIHZhcmlhYmxlcywgYW5k IHNvIG9uLCB3aXRob3V0IGRpc3R1cmJpbmcgdGhlIHBvcnRhbC4pDQoNCkFsbCBwb3J0YWxz IGFyZSBpbXBsaWNpdGx5IGNsb3NlZCBhdCB0cmFuc2FjdGlvbiBlbmQuIFRoZXJlZm9yZSBh IA0KcmVmY3Vyc29yIHZhbHVlIGlzIHVzYWJsZSB0byByZWZlcmVuY2UgYW4gb3BlbiBjdXJz b3Igb25seSB1bnRpbCB0aGUgZW5kIA0Kb2YgdGhlIHRyYW5zYWN0aW9uLiINCg0KPiANCj4g SXMgaXQgZmFpciB0byBzYXkgdGhhdCB0aGUgUEwvcGdTUUwgcmVmY3Vyc29yIGlzIHVzZWZ1 bCwgYXQgYmVzdCwgb25seSBpbiB2ZXJ5IHNwZWNpYWwgdXNlLWNhc2VzPw0KPiANCg0KLS0g DQpBZHJpYW4gS2xhdmVyDQphZHJpYW4ua2xhdmVyQGFrbGF2ZXIuY29tDQoNCg==