Horton

Re: UNNEST result order vs Array data

Vik Fearing <vik.fearing@dalibo.com>

View thread View on postgr.es
From: Vik Fearing <vik.fearing@dalibo.com>
To: gmb <gmbouwer@gmail.com>
Cc: pgsql-sql@postgresql.org
Date: 2013-06-20T10:45:22Z
Lists: pgsql-sql 
On 06/20/2013 12:40 PM, gmb wrote:
> 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

Order is never guaranteed unless you specify an ORDER BY clause.