subject:"\[GENERAL\] Multiple unnests in query"

Re: [GENERAL] Multiple unnests in query

2017-11-12 Thread Tom Lane

Aron Widforss writes: > Is this first query expected behavior? If so, what is the rationale? The short answer is "because it's always worked that way". You might find the last half of section 37.4.8 illuminating:

[GENERAL] Multiple unnests in query

2017-11-12 Thread Aron Widforss

Good night, Is this first query expected behavior? If so, what is the rationale? I would have expected nine rows returned (as in my second example). Regards, Aron Widforss SELECT unnest(ARRAY[1, 1, 2]) AS unnested1, unnest(ARRAY[3, 3, 4]) AS unnested2 ; unnested1 | unnested2