On Thu, Jun 9, 2011 at 8:39 AM, Gordon Niessen <gordon@...> wrote:

>
>
> 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.
>

Because distinct needs to sort in order to work.

Tom Clarke.

>
> --
> Thanks,
>
> Gordon
>
> [Non-text portions of this message have been removed]
>
>
>

--
Thomas Clarke
Cyber Sea Incorporated
#6 Kingston Terrace
Flint Hall
St. Michael
Barbados BB11070

voice: (246) 234-9692
email: tclarke@...
web: http://cybersea.biz


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