Re: Set-Returning functions in a select list - Mailing list pgsql-general

From Tom Lane
Subject Re: Set-Returning functions in a select list
Date
Msg-id 1163940.1627142622@sss.pgh.pa.us
Whole thread Raw
In response to Set-Returning functions in a select list  (J Lumby <johnlumby@hotmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: J Lumby
Date:
Subject: Set-Returning functions in a select list
Next
From: Indrajit Datar
Date:
Subject: regarding sql password auth