Re: UNNEST result order vs Array data

From: gmb <gmbouwer(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: UNNEST result order vs Array data
Date: 2013-06-20 12:13:14
Message-ID: 1371730394987-5760106.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


>> An array is ordered. If you turn it into a relation then it isn't
>> ordered any more until you apply ORDER BY.
>>
>> An unnest() will almost certainly scan the array in-order, but once you
>> embed that in a large query the ordering is no longer guaranteed.

Thanks, I assumed as much. Appreciate your help.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/UNNEST-result-order-vs-Array-data-tp5760087p5760106.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message gmb 2013-06-20 12:32:24 Re: UNNEST result order vs Array data
Previous Message Vik Fearing 2013-06-20 12:11:35 Re: UNNEST result order vs Array data