October 2001
Beginner to intermediate
400 pages
7h 45m
English
PostgreSQL includes many functions that assist in performing numerical calculations. The following sections discuss the included numerical functions in PostgreSQL.
The ABS function returns the absolute value of a supplied number.
ABS(num) ABS(-7) → 7 ABS(-7.234) → 7.234
The ABS function’s return value is the same data type that it is passed.
The ACOS function returns an inverse cosine.
ACOS(num) The ASIN function returns an inverse sine.
ASIN(num) The ATAN function returns an inverse tangent.
ATAN(num) The ATAN2 function returns an inverse tangent of y/x.
ATAN2(x,yRead now
Unlock full access