Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Upe2T-0000jo-Bb for pgsql-sql@arkaria.postgresql.org; Thu, 20 Jun 2013 12:32:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Upe2S-0005eb-Ra for pgsql-sql@arkaria.postgresql.org; Thu, 20 Jun 2013 12:32:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Upe2S-0005eV-7J for pgsql-sql@postgresql.org; Thu, 20 Jun 2013 12:32:32 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Upe2L-0005KN-CW for pgsql-sql@postgresql.org; Thu, 20 Jun 2013 12:32:31 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Upe2K-00069a-0n for pgsql-sql@postgresql.org; Thu, 20 Jun 2013 05:32:24 -0700 Date: Thu, 20 Jun 2013 05:32:24 -0700 (PDT) From: gmb To: pgsql-sql@postgresql.org Message-ID: <1371731544016-5760107.post@n5.nabble.com> In-Reply-To: <51C2F177.8020808@dalibo.com> References: <1371724857304-5760087.post@n5.nabble.com> <51C2DD42.4000002@dalibo.com> <1371726033207-5760092.post@n5.nabble.com> <51C2F177.8020808@dalibo.com> Subject: Re: UNNEST result order vs Array data MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org >> The best, which you won't >> like, is to wait for 9.4 where unnest() will most likely have a WITH >> ORDINALITY option and you can sort on that. The fact that this type of thing is on the 9.4 roadmap indicates (to me, in any case) that there are problems with the UNNEST functionality in the current version (I'm running 9.2). Thanks Vik, I'll take a look at the implementation you suggested. -- View this message in context: http://postgresql.1045698.n5.nabble.com/UNNEST-result-order-vs-Array-data-tp5760087p5760107.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql