Name

__min_notnull — Returns minimum value among all its arguments, ignoring NULLs entirely.

Synopsis

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

Description

The function returns the minimum value among all values in all its arguments by ignoring NULLs entirely.

Parameters

argI

Values which can be with type float, integer etc.

Examples

Example 24.194. 

Example 1

SQL> select __min_notnull (null, 1, 0);
__min_notnull
VARCHAR
_______________________________________________________________________________

0

1 Rows. -- 0 msec.
SQL> select __min (null, 1, 0);
__min
VARCHAR
_______________________________________________________________________________

NULL

1 Rows. -- 0 msec.

Example 2

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

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

SQL> SPARQL SELECT ?s, (bif:__min_notnull (?pr1, ?pr2, ?pr3))
FROM <http://mygraph.com>
WHERE
  {
    {
      SELECT DISTINCT ?s
      WHERE
        {
          ?s ?p ?pr .
          FILTER (?p in (<price1>, <price2>, <price3>))
        }
    }
    OPTIONAL { ?s <price1> ?pr1 }
    OPTIONAL { ?s <price2> ?pr2 }
    OPTIONAL { ?s <price3> ?pr3 }
  };

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

No. of rows in result: 2