# 22. Virtuoso Functions Guide - min

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
and
append
assign
avg
boolean
ceiling
concat
contains
count
create-attribute
create-comment
create-element
create-pi
current
distinct
doc
document
document-literal
empty
ends-with
every
except
false
filter
floor
fn:collection
for
format-number
function-available
generate-id
id
if
intersect
is_after()
is_before()
key
lang
last
let
list()
local-name
max
min
name
namespace-uri
normalize-space
not
number
or
position
processxquery
processxslt
processxsql
progn()
replace()
round
serialize
shallow
some
starts-with
string
string-length
substring
substring-after
substring-before
sum
system-property
text_contains()
translate
true
tuple()
union
unordered
unparsed-entity-uri
urlify
xmlview
Functions Index

## min

Returns minimum value among all its arguments.
number min ( arg1 any, arg2 any, ... , argN any);
Description

The function returns the minimum value among all values in all its arguments, For each node in every argument node-set, it converts the string-value of the node to a number. If some arguments are not node-sets, they are converted to numbers. The minimum number found is returned.

This function is not a part of XPATH 1.0 standard library.

Parameters
argI – A node-set of nodes whose string values must be converted to numbers and added to the result, or single value.
Return Types

Table: 22.1. Errors signalled by min()
SQLState | Error Code | Error Text | Description
--- | --- | --- | ---
XP001 | XPF04 | Nonempty sequence of values expected as argument of XPATH function min(); min() of nothing is senseless | This happens if the function is called without arguments, or with all arguments set to empty node-sets.

Examples

    min(/report[@type="daily-sales"]/total)

See Also

sum avg max