Top

Name

__min — Returns minimum value among all its arguments.

Synopsis

any __min ( arg1 any ,
  arg2 any ,
  ... ,
  argN any );
 

Description

The function returns the minimum value among all values in all its arguments.

Parameters

argI

Values which can be with type float, integer etc.

Examples

Example 24.191. 

Example 1

SQL> select __min(12, 2.34, 5, 20);
__min
VARCHAR
_______________________________________________________________________________

2.34

1 Rows. -- 32 msec.

Example 2

SQL> SPARQL
INSERT INTO GRAPH <http://mygraph2.com>
  {
    <http://mygraph2.com/pricing/#QVal1> <price1>  1 ; <price2> 9 ; <price3> 5 .
    <http://mygraph2.com/pricing/#QVal2> <price1>  3 ; <price2> 1 ; <price3> 4 .
    <http://mygraph2.com/pricing/#QVal3> <price1>  6 ; <price2> 2 ; <price3> 2 .
  };

Insert into <http://mygraph.com>, 9 (or less) triples -- done
No. of rows in result: 1

SQL> SPARQL SELECT ?s (bif:__min(?pr1, ?pr2, ?pr3))
FROM <http://mygraph2.com>
WHERE
  {
    ?s <price1> ?pr1 ;
       <price2> ?pr2 ;
       <price3> ?pr3
  };

Query result:
s                                     callret-1
VARCHAR 	                            VARCHAR
_______________________________________________
http://mygraph2.com/pricing/#QVal3	  2
http://mygraph2.com/pricing/#QVal2	  1
http://mygraph2.com/pricing/#QVal1	  1

No. of rows in result: 3