Multiple unnests in query

From: Aron Widforss <pgsql-general(at)antarkt(dot)is>
To: pgsql-general(at)postgresql(dot)org
Subject: Multiple unnests in query
Date: 2017-11-13 01:22:58
Message-ID: 1510536178.2747282.1170204616.4A024CB2@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
-----------+-----------
1 | 3
1 | 3
2 | 4
(3 rows)

SELECT
unnest(ARRAY[1, 1, 2]) AS unnested1,
sec
FROM (SELECT 3 AS sec UNION ALL
SELECT 3 AS sec UNION ALL
SELECT 4 AS sec) test
;
unnested1 | sec
-----------+-----
1 | 3
1 | 3
2 | 3
1 | 3
1 | 3
2 | 3
1 | 4
1 | 4
2 | 4
(9 rows)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-11-13 01:51:01 Re: Multiple unnests in query
Previous Message Weiping Qu 2017-11-13 00:34:11 ways of monitoring logical decoding performance