Saving all output to "!!{outputDirectory}!!/udf_xpath_float.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/udf_xpath_float.q
>>>  DESCRIBE FUNCTION xpath_float ;
'tab_name'
'xpath_float(xml, xpath) - Returns a float value that matches the xpath expression'
1 row selected 
>>>  DESCRIBE FUNCTION EXTENDED xpath_float ;
'tab_name'
'xpath_float(xml, xpath) - Returns a float value that matches the xpath expression'
'Example:'
'  > SELECT xpath_float('<a><b>1</b><b>2</b></a>','sum(a/b)') FROM src LIMIT 1;'
'  3.0'
4 rows selected 
>>>  
>>>  SELECT xpath_float ('<a>this is not a number</a>', 'a') FROM src LIMIT 1 ;
'_c0'
'NaN'
1 row selected 
>>>  SELECT xpath_float ('<a>this 2 is not a number</a>', 'a') FROM src LIMIT 1 ;
'_c0'
'NaN'
1 row selected 
>>>  SELECT xpath_float ('<a><b>2000000000</b><c>40000000000</c></a>', 'a/b * a/c') FROM src LIMIT 1 ;
'_c0'
'7.999999984405158E19'
1 row selected 
>>>  SELECT xpath_float ('<a>try a boolean</a>', 'a = 10') FROM src LIMIT 1 ;
'_c0'
'0.0'
1 row selected 
>>>  SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'a/b') FROM src LIMIT 1 ;
'_c0'
'1.0'
1 row selected 
>>>  SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/*)') FROM src LIMIT 1 ;
'_c0'
'15.0'
1 row selected 
>>>  SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b)') FROM src LIMIT 1 ;
'_c0'
'7.0'
1 row selected 
>>>  SELECT xpath_float ('<a><b class="odd">1</b><b class="even">2</b><b class="odd">4</b><c>8</c></a>', 'sum(a/b[@class="odd"])') FROM src LIMIT 1 ;
'_c0'
'5.0'
1 row selected 
>>>  !record