Hi all
I just want to confirm something regarding UNNEST function used with arrays.
I cannot see that it is specifically mentioned in the documentation , but
maybe because it is obvious.
Is the order of the result guaranteed to be the order of the array
I.e. is it possible that:
SELECT UNNEST( ARRAY[1,2,3] )
will sometimes return:
unnest
--------
2
1
3
(3 rows)
instead of:
unnest
--------
1
2
3
(3 rows)
Help will be appreciated
--
View this message in context: http://postgresql.1045698.n5.nabble.com/UNNEST-result-order-vs-Array-data-tp5760087.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.