Postgres Pro
Downloads
Home   >   mailing lists

Re: UNNEST result order vs Array data - Mailing list pgsql-sql

From Vik Fearing
Subject Re: UNNEST result order vs Array data
Date
Msg-id 51C2DD42.4000002@dalibo.com
Whole thread Raw
In response to UNNEST result order vs Array data  (gmb <gmbouwer@gmail.com>)
Responses Re: UNNEST result order vs Array data
Re: UNNEST result order vs Array data
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: gmb
Date:
Subject: UNNEST result order vs Array data
Next
From: gmb
Date:
Subject: Re: UNNEST result order vs Array data