On 6/8/2011 1:49 PM, Gordon Niessen wrote:

>
> While it does say in the 2.1 language reference for LIST() that "The
> order of the list values is undefined". I would have though that they
> would be in the order of the presented rows. So if the underlying query
> has them sorted I would have expected them to maintain that order. But
> that does not appear to happen.
>
> Is there any way to order the list? Other then writing my own UDF?
>
> --
> Thanks,
>
> Gordon
>

Interestingly, if I use DISTINCT, I get an ordered list.

--
Thanks,

Gordon



[Non-text portions of this message have been removed]