Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rumwr-007eZc-EI for pgsql-general@arkaria.postgresql.org; Thu, 11 Apr 2024 05:26:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rumwq-00DLJw-6L for pgsql-general@arkaria.postgresql.org; Thu, 11 Apr 2024 05:26:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rumwp-00DLJo-PK for pgsql-general@lists.postgresql.org; Thu, 11 Apr 2024 05:26:07 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rumwk-000K3v-Lj for pgsql-general@lists.postgresql.org; Thu, 11 Apr 2024 05:26:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1712813160; x=1713417960; i=shammat@gmx.net; bh=YPSwKHMKlRO1GdMoA4tW3410fksdxh9573ZwSB5z4FQ=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=cd9+UJkpQh7PQyRzqXYNx7TXM79k78pIc7MZZKXX8TEvI0IpG4KN87gHkKoOaeVB Niq9IC4jgpIDw8ytMtneOmeJYSKoayXtrR200f3usfVb4aSwjSmRRi8IWR4Pvvroi tp1r/EneGqfJPwo+jZhZ3T5EdS2kA6VAVGtINWBusZ+Pc1Dvpyh8nmSqpUGUjz2i0 QejKpd/qmWAUOub8lG2MLhzWwNaQ8lVvQ/ueW2vsBnrAPGPFapvLyDYq9qnVmsFrh tp0hhMnc41O3lEzeEY/jgFNKedIfnUK5JboL/UMjsXQCyrRbzL19QwoiNSjIYYaH4 VJGVyvnRvjOxobAY1A== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.152] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1Md6R1-1sTIol1Ckt-00aFZy for ; Thu, 11 Apr 2024 07:26:00 +0200 Message-ID: <43e14d4d-6ed9-4140-a630-5a2b1d5a9d87@gmx.net> Date: Thu, 11 Apr 2024 07:25:59 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: (When) can a single SQL statement return multiple result sets? To: pgsql-general@lists.postgresql.org References: <20240410232247.b48cdf2677f87d37b167e140@magnetkern.de> <7504.1712790168@sss.pgh.pa.us> Content-Language: de-DE From: Thomas Kellerer In-Reply-To: <7504.1712790168@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:Rc9RjRQwnyDSmBvcFsZfpy6gDXkuGJiZ69FLBZ7IRzIW4l9uGLt fVJ9BQ9V1goBtSKgHSSvplfJmX+nu/Yr8CQuz6t7TGsOSr5f9U1uasXBCWNk9Li4Ow/j1gP elH3UpJpL6aptmZwUPO9TYjBPRnzFpOllmLz1oTfD6DmciWUJ4VKwGG+tI9UW0weJNhFn1K tB+HTm3FzTRZ32hntyiVA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:baB+1WsHZMY=;C9UT31qdFITMwh5SCB/gAIF7iSD Cts4n5dP5FNRJrfRSsbdNFYgJ3gORX2Kwycm9TUx5vGtFtb+EEhODp0M57QS+5mwVmbkjQDL7 3Iua7K87tWBcR6j242i1JOt4jXJpiUlmwmm5PjAUnQy7mc14qvSohbAASB8fxBWn3FZJdq6/6 jNPyK9wE5B2YiZiVcO8acFIxBMghuGAu4IP9RADbFr3jYTcyU3EDsZsGODtJgRt1/imWaQ6p3 hbnjRxkz92FruOfnLNNUKQZfWxZ7rZO3QQu2KkpDebfV5BLEtwsESDfX4r9YTJFPUZRu3X6qW +UmwoNxIHr6zaQ1sx6sZ9wjeGbSxG2oKVlHYV8ny6LYJeEZBkf8XSz4yyfCnNXuWbOlWwLLmc CSsJirH2JlPETqHJ0ZEPvIeZod7DpvuIx5aEjtr0iboMX8+5aQe+ceeNOzdxng+yM19eczBYJ QXfvAx5PWn9PtBUmd40ai/MCkN+6L5IYd5BUCYs/XGa7R6QW4Wj0O9yktNw6vcudIgWL7iKQt aXvfzBV+yIZSxqso5sFbGAQIJ/wHKsqxYeN7O4+Q9zzYDv/5AWB53kRv9/f8nz9wG/dkQBjNP AaGYxmGqI5eXahE7COJbF483Uj6THeUuLu8FgEfEBhu8e+UsGu/lBIxcz0K7qKWr0ekGoMvMI U56pZq/89SNKweUNR5qYSQrCeitss//oDa0rPvV4zmrWWWgdlmu78KldXRsywJYOjM9NiDGng Nj1YE1kBnMnWtCjIWCs8ohE3ZqrAvW8O4eIgDkrHUTLB+G41YPX91r+PRN4NGsMH+hTb/h1/W NzDIeB5a61Ib/UPx+RLvCisV87EsvQNfdVOi8o8KZPxNs= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Tom Lane schrieb am 11.04.2024 um 01:02: > Jan Behrens writes: >> While writing a PostgreSQL client library for Lua supporting >> Pipelining (using PQsendQueryParams), I have been wondering if there >> are any single SQL commands that return multiple result sets. > > Right now, I don't think so. Hmm, what about functions returning multiple refcursors? =46rom a client library point of view, I think that would qualify as "multiple result sets"