UNNEST result order vs Array data

gmb <gmbouwer@gmail.com>

From: gmb <gmbouwer@gmail.com>
To: pgsql-sql@postgresql.org
Date: 2013-06-20T10:40:57Z
Lists: pgsql-sql
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.