Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37333=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1UpcMv-0003VD-Ce
 for pgsql-sql@arkaria.postgresql.org; Thu, 20 Jun 2013 10:45:33 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37333=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1UpcMu-0003op-TG
 for pgsql-sql@arkaria.postgresql.org; Thu, 20 Jun 2013 10:45:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <vik.fearing@dalibo.com>) id 1UpcMt-0003oi-Uo
 for pgsql-sql@postgresql.org; Thu, 20 Jun 2013 10:45:32 +0000
Received: from mimolette.dalibo.net ([212.85.154.222])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <vik.fearing@dalibo.com>) id 1UpcMn-0003MQ-DF
 for pgsql-sql@postgresql.org; Thu, 20 Jun 2013 10:45:31 +0000
Received: from [192.168.0.28] (ip-68.net-81-220-133.standre.rev.numericable.fr
 [81.220.133.68])
 by mimolette.dalibo.net (Postfix) with ESMTPSA id 9CB844501ADC;
 Thu, 20 Jun 2013 12:45:24 +0200 (CEST)
Message-ID: <51C2DD42.4000002@dalibo.com>
Date: Thu, 20 Jun 2013 12:45:22 +0200
From: Vik Fearing <vik.fearing@dalibo.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130510 Thunderbird/17.0.6
MIME-Version: 1.0
To: gmb <gmbouwer@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: UNNEST result order vs Array data
References: <1371724857304-5760087.post@n5.nabble.com>
In-Reply-To: <1371724857304-5760087.post@n5.nabble.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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.


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