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)
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 |