一、 操作符表

操作符描述示例结果+加4+711-减4-7-3*乘4*711/除(整数除法将截断结果)7/32%模(求余)6%42^幂(指数运算)3^327|/平方根|/366||/立方根||/82!阶乘5!120!!阶乘(前缀操作符)!!5120@绝对值@-5.05&二进制AND31&1515|二进制OR31|1531#二进制XOR31#1516~二进制NOT~1-2<<二进制左移1<<8256>>二进制右移16>>32

二、函数表

“dp” 表示double precision。

操作符描述示例结果abs(x)绝对值abs(-23.7)23.7cbrt(dp)立方根cbrt(8)2ceil/ceiling(dp或numeric)不小于参数的最小整数ceil(-38.1) ceil(38.1) ceiling(38.1)-38 39 39degrees(dp)把弧度转为角度degrees(1)57.29577951308232exp(dp或numeric)自然指数exp(1)2.7182818284590452floor(dp或numeric)不大于参数的最大整数floor(-42.8) floor(-42.8)-43 42ln(dp或numeric)自然对数ln(2.7182818284590452)1.0000000000000000log(dp或numeric)以10为底的对数log(1000)3log(b numeric,x numeric)以b为底的对数log(2,32)5.0000000000000000mod(y,x)y/x的余数(模)mod(7,3)1pi()π常量pi()3.141592653589793power(a dp或numeric,b dp或numeric)a的b次幂power(2,3)8radians(dp)把角度转成弧度radians(45)0.7853981633974483random()0到1之间的随机数random()随机返回一个小数round(dp或numeric)圆整为最接近的整数(四舍五入)round(36.5)37round(v numeric,s int)圆整为s位小数(四舍五入)round(36.5252,2)36.53setseed(dp)为随后的random()调用设置种子(0到1之间)setseed(0.123)每次种子后，重现相同随机数sign(dp或numeric)参数的符号(-1,0,+1)sign(-8.4)-1sprt(dp或numeric)平方根sqrt(9)3trunc(dp或numeric)截断(向零靠近)trunc(42.8)42trunc(v numeric,s int)截断为s位小数trunc(42.4382,2)42.43width_bucket(op numeric,b1 numeric,b2 numeric,count int)返回包含count等宽柱的柱状图中operand所在的柱的编号，范围从low到high，超出该范围的输入则返回0或计数+1width_bucket(5.35,0.024,10.06,5)3acos(x)反余弦acos(1) acos(-1)0 3.141592653589793asin(x)反正弦asin(0) asin(1)*20 3.141592653589793atan(x)反正切atan(1)0.7853981633974483atan2(x,y)x/y的反正切atan2(1,1)0.7853981633974483cos(x)余弦cos(pi()) cos(0)-1 1cot(x)余切cot(0)Infinitysin(x)正弦sin(0) sin(pi()/2)0 1tan(x)正切tan(pi()/4)0.9999999999999999

好文链接

评论可见，请评论后查看内容，谢谢！！！评论后请刷新页面。