The following bug has been logged on the website:
Bug reference: 13486
Logged by: Long Zou
Email address: longzou@hotmail.com
PostgreSQL version: 9.4.4
Operating system: Mac OS X
Description:
I have a query that using the unnest function. But I don't know how to sort
the result.
For example:
select * from unnest(array[1,2,3,4,5,6], array[10,8,3,6,8,2], array['ab',
'dd','','dd','st']);
The result will have three columns and those name are 'unnest'. So, if I use
unnest as the order by cause, it will raise an error:
ERROR: ORDER BY "unnest" is ambiguous.