modules/calcite/src/test/sql/function/numeric/test_pg_math.test

# name: test/sql/function/numeric/test_pg_math.test
# description: Function test cases from PG docs
# group: [numeric]

# see https://www.postgresql.org/docs/10/functions-math.html

query R
select pi
----
3.141592653589793

query R
select abs(-17.4)
----
17.400000

query R
select cbrt(27.0)
----
3.000000

query R
select ceil(-42.8)
----
-42.000000

query R
select ceiling(-95.3)
----
-95.000000

query R
select CAST(exp(1.0) AS FLOAT)
----
2.7182817

query R
select floor(-42.8)
----
-43.000000

query R
select CAST(ln(2.0) AS FLOAT)
----
0.6931472

query R
select log10(100.0)
----
2.000000

query R
select CAST(sqrt(2.0) AS FLOAT)
----
1.4142135

query R
select CAST(radians(45.0) AS FLOAT)
----
0.7853982

query R
select CAST(degrees(0.5) AS FLOAT)
----
28.647890

query I
select sign(4.1)
----
1

query I
select sign(-4.1)
----
-1

query I
select sign(0)
----
0

query I
select sign(3)
----
1