(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 121 Chapter 9. Functions and Operators Operator Description Example Result |/ square root |/ power(a dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) 0 Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial 5 ! 120 !! factorial (prefix operator) power(9.0, 3.0) 729 116 Chapter 9. Functions and Operators Function Return Type Description Example Result power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial 5 ! 120 !! factorial (prefix operator) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial 5 ! 120 !! factorial (prefix operator) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial 5 ! 120 !! factorial (prefix operator) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) 4.0.1) NetBSD m68k 8.2.0 Build farm osprey (2.0, gcc 3.3.3) NetBSD x86 8.2.0 Build farm gazelle (3.0, gcc 3.3.3); canary (1.6, gcc 2.95.3) OpenBSD AMD64 8.2.0 Build farm zebra (4.0, gcc 3.3.5) OpenBSD

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial 5 ! 120 !! factorial (prefix operator) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) 4.0.1) NetBSD m68k 8.2.0 Build farm osprey (2.0, gcc 3.3.3) NetBSD x86 8.2.0 Build farm gazelle (3.0, gcc 3.3.3); canary (1.6, gcc 2.95.3) OpenBSD AMD64 8.2.0 Build farm zebra (4.0, gcc 3.3.5) OpenBSD

result) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation (asso- ciates left to right) 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial (deprecated, use factorial() instead) b dp) dp a raised to the pow- er of b power(9.0, 3.0) 729 power(a nu- meric, b nu- meric) numeric a raised to the pow- er of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45 Note that server_version, server_encoding and in- teger_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain values for server_version

result) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation (asso- ciates left to right) 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial (deprecated, use factorial() in- dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a nu- meric, b nu- meric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radi- ans(45 Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

result) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation (associates left to right) 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial (deprecated, use factorial() instead) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

result) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation (associates left to right) 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial (deprecated, use factorial() instead) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for