← Back to all TILs

Two Ways To Compute Factorial

postgres Written December 26, 2015

In PostgreSQL, there are two ways to compute the factorial of a number. There is a prefix operator and a postfix operator. The prefix operator is !! and can be used like so:

> select !!5;
 ?column?
----------
      120

The postfix operator is ! and can be used like so:

> select 5!;
 ?column?
----------
      120

See the mathematical functions and operators docs for more details.

Other posts like this