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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql