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 1pcgTW-0004pA-BA for pgsql-general@arkaria.postgresql.org; Thu, 16 Mar 2023 05:48:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pcgTV-0000hX-7u for pgsql-general@arkaria.postgresql.org; Thu, 16 Mar 2023 05:48:29 +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 1pcgTU-0000hN-TD for pgsql-general@lists.postgresql.org; Thu, 16 Mar 2023 05:48:28 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pcgTS-0003T9-Op for pgsql-general@lists.postgresql.org; Thu, 16 Mar 2023 05:48:28 +0000 Received: by mail-ed1-x536.google.com with SMTP id y4so3216852edo.2 for ; Wed, 15 Mar 2023 22:48:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; t=1678945706; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=0NGfsYsnanj4uHF1iG0v4Isj05Ml0YUiPu3RQ1LgbHc=; b=SQ/E69FN4JSIRfU3d6gnx80M7/Pn7C9hoIKSINajvtt+S9edb6jMEVCk6PYE22hqXt hfV6srjaKVkAwgDazbyIxL9RcJttGIfMVKjkizeoGyu3a8x0Y4vkp7KQwe4yIbmQwX5r TbPBImKNMWFTVdqLYPVnaxXIciB4JCgU1tPzBLotCVU7mDMcxMqSspH0X8h2qE8LbncC Xh+r+wC/Oeub4c8BKn7CwX6ay65WqaIQDbGLYmhR+SngC9bAnGlrDabT1oLviUaTvAfc diWi/5aIKTj/AlJR+StM4wcbsWDH8qOJLajK0MoJXHh3FP4TyJIk9S/0lV6zA9AxhO+8 KmVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678945706; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=0NGfsYsnanj4uHF1iG0v4Isj05Ml0YUiPu3RQ1LgbHc=; b=dNJyi302zZamE1BFUWpVNhoy+Axky87Eoi4NmcjUQ2ynu+YA+vxL5TWqhmXIwHLJ3K ViLEzXKK2WswTnTEehIKVuW+mOmvycQxWcxWhozp95NI5PdQGhAoL3YwqKEDirVAFxGb obNZrm38L2/6UxlfS74QmDasXJrox6Qxd8XUWIW+0yHxYa5UqnmkszFRyC/3DJMsZPM3 7ZupurTHwiZtCq4M85XMyI+Do7m8FhDr6MJ4R6/fuXiodyqKmh2Pf3VdgVS+ZiNJd2Dx 9gPM2pe3ioOJzKYzN/PUK8ZBRlDBW0XsJp+mu12kvtEZLWGTkqovBymTuDrpJ0mg4VaB P43g== X-Gm-Message-State: AO0yUKVofQB/rNx2A7+Jj6NlWrmamLpfc9X948duVSjscSoH4bYJM4px wLxcvV/owPxm63X0md4xfFC5VesgK5F8/wbZte31/A== X-Google-Smtp-Source: AK7set9gDKpTtIxrBhOUa1aGfemtkgovp9I8k/Nq7TifQE8ahEob2Todt3h/pvAY6erZQ+GXL4+gbw== X-Received: by 2002:a17:907:1ddc:b0:930:28d6:4581 with SMTP id og28-20020a1709071ddc00b0093028d64581mr1490191ejc.59.1678945705866; Wed, 15 Mar 2023 22:48:25 -0700 (PDT) Received: from localhost.localdomain (p50992f7c.dip0.t-ipconnect.de. [80.153.47.124]) by smtp.gmail.com with ESMTPSA id dt5-20020a170906b78500b008e82cb55195sm3379031ejb.203.2023.03.15.22.48.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 15 Mar 2023 22:48:25 -0700 (PDT) Message-ID: Subject: Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? From: Laurenz Albe To: Bryn Llewellyn , Adrian Klaver Cc: pgsql-general list Date: Thu, 16 Mar 2023 06:48:24 +0100 In-Reply-To: <5637673F-472A-49F6-87EF-DCE57879039B@yugabyte.com> References: <6A73AAEA-7A9F-42C9-A842-88213FA41003@yugabyte.com> <7992035C-058A-4AB7-915A-41A3914E3A63@yugabyte.com> <5637673F-472A-49F6-87EF-DCE57879039B@yugabyte.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Well, it is simple. As we wrote, some of us think that cursors are useful, and we tried to explain why we think that. If you don't think that cursors are useful, don't use them. We are not out to convince you otherwise. Yours, Laurenz Albe