home contribute faq download

FunctX XQuery Functions

functx:sort-as-numeric

Sorts a sequence of numeric values or nodes

Google
Webdatypic.com

Description

The functx:sort-as-numeric function sorts a sequence of numeric values or nodes. This is useful for untyped values, because the order by clause by default treats values as strings, and would therefore sort 100 before 99.

Arguments and Return Type

NameTypeDescription
$seq item()* the sequence to sort
return value item()*

XQuery Function Declaration

See XSLT definition.
declare namespace functx = "http://www.functx.com";
declare function functx:sort-as-numeric
  ( $seq as item()* )  as item()* {

   for $item in $seq
   order by number($item)
   return $item
 } ;

Examples

let $in-xml :=
<in-xml>
  <f>1</f>
  <f>35</f>
  <e>4</e>
</in-xml>
return
XQuery ExampleResults
functx:sort-as-numeric(('1','100','99'))
('1', '99', '100')
functx:sort-as-numeric($in-xml/*)
<f>1</f>
<e>4</e>
<f>35</f>

See Also

functx:sortSorts a sequence of values or nodes
functx:sort-case-insensitiveSorts a sequence of values or nodes regardless of capitalization
functx:sort-document-orderSorts a sequence of nodes in document order

History

Published OnLast UpdatedContributor(s)
2006-06-272007-02-26Priscilla Walmsley, Datypic, pwalmsley@datypic.com, https://www.datypic.com
Datypic XQuery Services

Recommended Reading:

XQuery