[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Set-Returning functions in a select list
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2021-07-24 16:03:42
Message-ID: 1163940.1627142622 () sss ! pgh ! pa ! us
[Download RAW message or body]

J Lumby <johnlumby@hotmail.com> <DM5PR06MB3082AEC288F546F7AF5393E3A3E69@DM=
5PR06MB3082.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,=C2=A0 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


[prev in list] [next in list] [prev in thread] [next in thread]