GreenPlum常用数值计算函数:
测试代码:
eda_gp=> select abs(-17.4);
abs
------
17.4
(1 row)
eda_gp=> select ceil(-15.7);
ceil
------
-15
(1 row)
eda_gp=> select ceiling(-15.7);
ceiling
---------
-15
(1 row)
eda_gp=> select exp(e);
ERROR: column "e" does not exist
LINE 1: select exp(e);
^
eda_gp=> select exp(1.0);
exp
--------------------
2.7182818284590452
(1 row)
eda_gp=> select ln(e);
ERROR: column "e" does not exist
LINE 1: select ln(e);
^
eda_gp=> select ln(1);
ln
----
0
(1 row)
eda_gp=> select log(100);
log
-----
2
(1 row)
eda_gp=> select log(2,6