Name

isfinitenumeric — returns 1 if its argument is of numeric type and its value is plain valid numeric value.

Synopsis

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

Example 24.189. Simple Use

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