Other Mathematical Operators

[JimKnicely]

In addition to the usual mathematical operators such as +, -, / and *, Vertical offers a few useful extras!

Example:

Code: Select all

dbadmin=> SELECT 5!     factorial,
dbadmin->        5 // 2 integer_division,
dbadmin->        @ -25  absolute_value,
dbadmin->        2 ^ 3  exponentiation,
dbadmin->        |/ 25  squaure_root,
dbadmin->        ||/ 27 cube_root,
dbadmin->        '$$$'  root_of_all_evil;
factorial | integer_division | absolute_value | exponentiation | squaure_root | cube_root | root_of_all_evil
-----------+------------------+----------------+----------------+--------------+-----------+------------------
       120 |                2 |             25 |              8 |            5 |         3 | $$$
(1 row)

Have fun!