The convention on these lists is to inline or, at worse, bottom-post. On Wed, May 3, 2023 at 7:34 AM J.A. <postgre...@world-domination.com.au> wrote:
> now select * from a _number_ of tables and return a -multi recordsets- > from this single query. I'm not sure if that is the same terminology, in > pgsql? > > So is this possible? > The output of a set-returning function (srf) is a single tabular result. If you want to produce multiple tabular results you would need to either serialize them (say into jsonb) or assign a cursor name to each and then reference them by name. David J.
