[xquery-talk] XQuery Order By Numerically

=?GB2312?B?1dTA1w==?= zhaolei at gmail.com
Sat Mar 1 00:52:44 PST 2008


What implementation are you using?

I use xqilla2, it works in the way you expect.

for $i in (1, 11, 2, 1234, 4, 123)
order by $i
return $i

/home/chuck/temp $ xqilla2 a.xq
1
2
4
11
123
1234

On 3/1/08, jz at uva <zhangjunte at gmail.com> wrote:
> Hi all,
>
>  The ORDER BY clause sorts the output alphabetically. However, how do I
>  sort the output numerically? Is this possible in XQuery?
>
>  For example, if the input is = {1, 11, 2, 1234, 4, 123), then the
>  ORDER BY clause sorts the results as {1, 11, 123, 1234, 2, 4).
>
>  How can I sort the results as {1, 2, 4, 11, 123, 1234}?
>
>  Thanks!
>  _______________________________________________
>  talk at x-query.com
>  http://x-query.com/mailman/listinfo/talk
>


More information about the talk mailing list