XQuery Order By Numerically

[jz at uva]

Hi,
Thank you. I am now using MonetDB4 and Pathfinder/PF/Tijah, and itdoes not work at all.
There is an ORDER BY, but it orders alphabetically. When I put thevariable between xs:integer, I get the error "reference to undefinedfunction `xs:integer'".
It's amazing that there are so many implementations doing differentthings (or not doing)...
If anyone knows an other way to achieve this, please let me know.
Thanks!
On Fri, Feb 29, 2008 at 5:52 PM, ÕÔÀ× <http://x-query.com/mailman/listinfo/talk> wrote:> 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, http://x-query.com/mailman/listinfo/talk <http://x-query.com/mailman/listinfo/talk> 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!>  >  _______________________________________________>  >  http://x-query.com/mailman/listinfo/talk>  >  http://x-query.com/mailman/listinfo/talk>  >>