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
Phrases
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
import_jar
internal_to_sql_type
internal_type
internal_type_name
isarray
isbinary
isblob
isdouble
isentity
isfinitenumeric
isfloat
isinteger
isnull
isnumeric
isstring
iszero
jvm_ref_import
make_string
sign
stringdate
stringtime
udt_defines_field
udt_get
udt_implements_metho...
udt_instance_of
udt_set
unimport_jar
UDDI
User Defined Types & The CLR
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY

Functions Index

isfinitenumeric

returns 1 if its argument is of numeric type and its value is plain valid numeric value.
isfinitenumeric ( arg anything);
Description

isfinitenumeric returns 1 if its argument is of numeric type and its value is plain valid numeric value, not a peculiarity like infinity or not-a-number.

Examples
SQL>  SPARQL 
INSERT INTO GRAPH <http://mygraph.com>
  { 
    <http://mygraph2.com/pricing/#QVal1> <price1>  1 ;    <price2> "";    <price3> 5 .
    <http://mygraph2.com/pricing/#QVal2> <price1>  "" ;   <price2> 1 ;    <price3> 4 .
    <http://mygraph2.com/pricing/#QVal3> <price1>  6 ;    <price2> 2 ;    <price3> "".
  };
  
Insert into <http://mygraph.com>, 9 (or less) triples -- done
No. of rows in result: 1

SQL> SPARQL SELECT ?s (bif:isfinitenumeric(?pr1))
FROM <http://mygraph.com>
WHERE 
  {
    ?s <price1> ?pr1 ;  
       <price2> ?pr2 ;  
       <price3> ?pr3 
  };  	
  
Query result:
s                                     callret-1
VARCHAR 	                            INTEGER
_______________________________________________
http://mygraph2.com/pricing/#QVal2	 0
http://mygraph2.com/pricing/#QVal1	 1
http://mygraph2.com/pricing/#QVal3	 1

No. of rows in result: 3