[xquery-talk] XQuery Order By Numerically

[jz at uva]

Hi all,
I got it working with the XPath2.0 function fn:number, seehttp://www.w3.org/TR/xpath-functions/#func-number
Thanks for all your help though! :)
2008/2/29 jz at uva <zhangjunte at gmail.com>:> Hi,>>  Thank you. I am now using MonetDB4 and Pathfinder/PF/Tijah, and it>  does not work at all.>>  There is an ORDER BY, but it orders alphabetically. When I put the>  variable between xs:integer, I get the error "reference to undefined>  function `xs:integer'".>>  It's amazing that there are so many implementations doing different>  things (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, ÕÔÀ× <zhaolei at gmail.com> 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, 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>  >  >>  >>