[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