Re: UNNEST result order vs Array data

From: Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>
To: gmb <gmbouwer(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: UNNEST result order vs Array data
Date: 2013-06-20 10:45:22
Message-ID: 51C2DD42.4000002@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message gmb 2013-06-20 11:00:33 Re: UNNEST result order vs Array data
Previous Message gmb 2013-06-20 10:40:57 UNNEST result order vs Array data