PostgreSQL: Mathematical Functions and Operators

Addition

numeric_type + numeric_type -> numeric_type

Unary Plus

+ numeric_type -> numeric_type

Subtraction

numeric_type - numeric_type -> numeric_type

Negation

- numeric_type -> numeric_type

Multiplication

numeric_type * numeric_type -> numeric_type

Division

numeric_type / numeric_type -> numeric_type

Modulo

numeric_type % numeric_type -> numeric_type

Exponentiation

numeric ^ numeric -> numeric

Square Root

|/ double precision -> double precision

Cube Root

||/ double precision -> double precision

Absolute Value

@ numeric_type -> numeric_type

Bitwise AND

integral_type & integral_type -> integral_type

Bitwise OR

integral_type | integral_type -> integral_type

Bitwise Exclusive OR

integral_type # integral_type -> integral_type

Bitwise NOT

~ integral_type -> integral_type

Bitwise Shift Left

integral_type << integer -> inregral_type

Bitwise Shift Right

integral_type >> integer -> integral_type

Absolute value

abs(numeric_type) -> numeric_type

Cube Root

cbrt(double precision) -> double precision

Nearest Integer Greater than or Equal to Argument

ceil(numeric) -> double precision

Convert Radians to Degrees

degrees(double precision) -> double precision

Integer Quotient of y/x (truncates towards 0)

div(y numeric, x numeric) -> numeric

Exponential

exp(numeric) -> numeric

Factorial

factorial(bigint) -> numeric

Nearest Integer Less Than or Equal to Argument

floor(numeric) -> numeric

Greatest Common Divisor

gcd(numeric_type, numeric_type) -> numeric_type

Least Common Multiple

lcm(numeric_type,numeric_type) -> numeric_type

Natural Logarithm

ln(numeric) -> numeric

Logarithm of x to base b

log(b numeric, x numeric) -> numeric

a raised to the power of b

power(a numeric, b numeric) -> numeric

Convert degrees to radians

radians(double precision) -> double precision

Round to nearest integer

round(numeric) -> numeric

Truncates v to s decimal places

trunc(v numeric, s integer) -> numeric