Stored Procedure Multiple Result Sets

From: David Harrigan <dharrigan(at)gmail(dot)com>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Stored Procedure Multiple Result Sets
Date: 2020-06-23 08:36:51
Message-ID: 20200623083651.f74aq5ezckeblcot@daffy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'm curious - is it possible for stored procedures to return multiple
result sets (similar to how a function can declare a setof refcursors
and return on those, then fetch the datasets). I've been looking
through the documentation on Stored Procedures (PostgreSQL 11 and 12)
and I can't seem to find an example of how that may be done.

Thank you.

-=david=-

I prefer encrypted and signed messages.
GPG Fingerprint: 110AF423364754E2880FADAD1C5285BFB20A22F9

No trees were harmed in the sending of this message, however, a number
of electrons were inconvenienced.

This email is sent without prejudice.

Browse pgsql-novice by date

  From Date Subject
Next Message Bee.Lists 2020-06-23 17:25:11 Re: Connections Increasing Slowly
Previous Message Bee.Lists 2020-06-23 02:32:56 Re: Connections Increasing Slowly