BUG #8226: Inconsistent unnesting of arrays

The following bug has been logged on the website:

Bug reference:      8226
Logged by:          Denis de Bernardy
Email address:      ddebernardy@yahoo.com
PostgreSQL version: 9.2.4
Operating system:   OSX
Description:        =


It looks like unnest() in a select statement doesn't behave consistently
based on the number of elements in the array.

This works as expected:

denis=3D# select 1 as a, unnest('{2,3}'::int[]) as b, unnest('{4,5,6}'::int=
[])
as c order by a, b, c;
 a | b | c =

---+---+---
 1 | 2 | 4
 1 | 2 | 5
 1 | 2 | 6
 1 | 3 | 4
 1 | 3 | 5
 1 | 3 | 6
(6 rows)

This doesn't (it's missing (1,3,4) and (1,2,5)):

denis=3D# select 1 as a, unnest('{2,3}'::int[]) as b, unnest('{4,5}'::int[])
as c order by a, b, c;
 a | b | c =

---+---+---
 1 | 2 | 4
 1 | 3 | 5
(2 rows)