Message-ID: <51C2E441.4020200@matrix.gatewaynet.com>
Date: Thu, 20 Jun 2013 14:15:13 +0300
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
 rv:17.0) Gecko/20130601 Thunderbird/17.0.6
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: UNNEST result order vs Array data
References: <1371724857304-5760087.post@n5.nabble.com>
 <51C2DD42.4000002@dalibo.com>
In-Reply-To: <51C2DD42.4000002@dalibo.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 20/06/2013 13:45, Vik Fearing wrote:
> 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.
>
>
I really think that the order should exactly reflect the order in the array.
Think of ARRAY as Relation + ORDER. Relation + Order gives an ARRAY, 
ARRAY should give Relation *and* ORDER in return.

-- 
Achilleas Mantzios


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql