Horton

Re: UNNEST result order vs Array data

gmb <gmbouwer@gmail.com>

View thread View on postgr.es
From: gmb <gmbouwer@gmail.com>
To: pgsql-sql@postgresql.org
Date: 2013-06-20T11:00:33Z
Lists: pgsql-sql 
Hi Vik
Thanks for the reply. 
Can you please give me an example of how the order is specified?
I want the result of the UNNEST to be in the order of the array field
E.g.
SELECT UNNEST ( ARRAY[ 'abc' , 'ggh' , '12aa' , '444f' ] );
Should always return:

 unnest
--------
 abc
 ggh
 12aa
 444f

How should the ORDER BY be implemented in the syntax?

Regards




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