Postgres Pro
Downloads
Home   >   mailing lists

Re: UNNEST result order vs Array data - Mailing list pgsql-sql

From gmb
Subject Re: UNNEST result order vs Array data
Date
Msg-id 1371726033207-5760092.post@n5.nabble.com
Whole thread Raw
In response to Re: UNNEST result order vs Array data  (Vik Fearing <vik.fearing@dalibo.com>)
Responses Re: UNNEST result order vs Array data
List pgsql-sql
Tree view 
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
--------abcggh12aa444f

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.

pgsql-sql by date:

Previous
From: Vik Fearing
Date:
Subject: Re: UNNEST result order vs Array data
Next
From: Achilleas Mantzios
Date:
Subject: Re: UNNEST result order vs Array data