ifNotFinite(x,y);
如果x不是Nan,Infinity,那么就取x,否则就取y,x可以是小数.
-- sql1
SELECT 0/2 as infimum, ifNotFinite(infimum,42);
-- sql2
SELECT 1/0 as infimum, ifNotFinite(infimum,42
ifNotFinite(x,y);
如果x不是Nan,Infinity,那么就取x,否则就取y,x可以是小数.
-- sql1
SELECT 0/2 as infimum, ifNotFinite(infimum,42);
-- sql2
SELECT 1/0 as infimum, ifNotFinite(infimum,42