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