Set-Returning functions in a select list

2021-07-24 Thread J Lumby
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. At a very high level,   what I see happening is that each Set-Returning expression causes the

Re: Set-Returning functions in a select list

2021-07-24 Thread Tom Lane
J Lumby 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://w