pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: J Lumby <johnlumby@hotmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Set-Returning functions in a select list
Date: Sat, 24 Jul 2021 12:03:42 -0400
Message-ID: <1163940.1627142622@sss.pgh.pa.us> (raw)
In-Reply-To: <DM5PR06MB3082AEC288F546F7AF5393E3A3E69@DM5PR06MB3082.namprd06.prod.outlook.com>
References: <159567011970.625.15282665367468168691@wrigleys.postgresql.org>
	<673790.1595689577@sss.pgh.pa.us>
	<DM5PR06MB3082AEC288F546F7AF5393E3A3E69@DM5PR06MB3082.namprd06.prod.outlook.com>

J Lumby <johnlumby@hotmail.com> <DM5PR06MB3082AEC288F546F7AF5393E3A3E69@DM5PR06MB3082.namprd06.prod.outlook.com> writes:
> I am unclear about the rules which postgresql uses in building a result 
> set when the select list ( see note ) contains several different 
> Set-Returning functions,  possibly with sets of different sizes.

The docs you want exist, but they're a bit buried ... see

https://www.postgresql.org/docs/current/xfunc-sql.html#XFUNC-SQL-FUNCTIONS-RETURNING-SET

In particular, the NOTE at the bottom of that section explains that
the behavior changed in v10.

			regards, tom lane





view thread (4+ messages)  latest in thread

Message-ID: <1163940.1627142622@sss.pgh.pa.us>
Permalink:  ../1163940.1627142622@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1163940.1627142622@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, johnlumby@hotmail.com, pgsql-general@postgresql.org
  Subject: Re: Set-Returning functions in a select list
  In-Reply-To: <1163940.1627142622@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox