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:
https://www.postgresql.org/docs/devel/static/xfunc-sql.html#XFUNC-SQL-FUNCTIONS-RE
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
---+--
