Re: Problem with factorial operator - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with factorial operator
Date
Msg-id 24820.1017947390@sss.pgh.pa.us
Whole thread Raw
In response to Problem with factorial operator  (Jean-Luc Lachance <jllachan@nsd.ca>)
List pgsql-general
Jean-Luc Lachance <jllachan@nsd.ca> writes:
> If you try it, you will get the same result, but it is the wrong answer.
> Factorial work up to 20. After that one gets negative results.

There's a TODO item to replace the existing integer-based factorial ops
with a NUMERIC-based one, which would work for output values up to
whatever the NUMERIC precision limit is (10^1000, I think).  Want to
work on that?

            regards, tom lane

pgsql-general by date:

Previous
From: tmorrison
Date:
Subject: Update to readline and Postgresql
Next
From: "Command Prompt, Inc."
Date:
Subject: Announce: SSL-ODBC Available