What is the expected behaviour for multiple set-returning functions in SELECT clause?
Postgres 10 or newer adds null values for smaller set(s). Demo with generate_series(): SELECT generate_series( 1, 2) AS row2 , generate_series(11, 13) AS row3 , generate_series(21, 24) AS row4; row2 | row3 | row4 —–+——+—– 1 | 11 | 21 2 | 12 | 22 null | 13 | 23 null | null | 24 … Read more