The following bug has been logged on the website: Bug reference: 8226 Logged by: Denis de Bernardy Email address: ddeberna...@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=# 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=# 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) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs