[xquery-talk] XQuery Order By Numerically

jz at uva zhangjunte at gmail.com
Fri Feb 29 18:01:24 PST 2008


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, ÕÔÀ× <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>  >>


More information about the talk mailing list