Re: Bug #534: factorial function - Mailing list pgsql-bugs

From Janko F. Richter
Subject Re: Bug #534: factorial function
Date
Msg-id 3C14D5F2.7090502@wallstreet-develop.de
Whole thread Raw
In response to Bug #534: factorial function  (pgsql-bugs@postgresql.org)
List pgsql-bugs
-------- Original Message --------
Subject: Re: [BUGS] Bug #534:  factorial function
Date: Mon, 10 Dec 2001 13:28:15 +0100
From: "Janko F. Richter" <j.richter@wallstreet-develop.de>
To: Bruce Momjian <pgman@candle.pha.pa.us>
References: <200112101121.fBABLgI23940@candle.pha.pa.us>

Hallo Bruce,

Bruce Momjian wrote:

 > Yep, 0! sure looks like a bug.  We will fix it in 7.3.  Not sure about
 > the double precision.  Comments?



Perhaps a good idea is to implement the Gamma function additional
to factorial function. The gamma function as general function of
factorial accepts float/double values as argument and returns double.


Maybe a good idea too is to implement a set of standard statistical
functions for instance normal, poisson, binomial, etc to get less range
overflow while using statistical functions.

Perhaps when I'll have time, I will try to write a set of this functions
as contrib next year.

Thank you and regards ,

Janko

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #534: factorial function
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #535: postgreSQL v7.1.3 doesn't build properly with gcc v3.0.2 on Solaris 8