[xquery-talk] XQuery Order By Numerically

Torsten Grust grust at in.tum.de
Fri Feb 29 18:18:46 PST 2008


Hi,

it'd help if you could show your (failing) example.  In the
meantime, for Pathfinder please replace xs:integer($x) by
$x cast as xs:integer.  Sorry for the hassle.  We're working
on it.

Hope this helps,
    --Torsten (Pathfinder team, TU Munich)

On Feb 29, 2008, at 18:01, jz at uva wrote:

> 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>  >>
> _______________________________________________
> talk at x-query.com
> http://x-query.com/mailman/listinfo/talk

-- 
   | Prof. Dr. Torsten Grust                         grust at in.tum.de |
   |                                 http://www-db.in.tum.de/~grust/ |
   |     Database Systems - Technische Universität München (Germany) |






More information about the talk mailing list