Re: [BUGS] Bug #534: factorial function

2002-02-22 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > Janko Richter ([EMAIL PROTECTED]) reports a bug > with a severity of 3 The lower the number the more severe it > is. > > Short Description factorial function > > Long Description 1. The factorial function returns 0 when the > argument is 0. The factorial Funtion is def

Re: [BUGS] Bug #534: factorial function

2001-12-29 Thread Bruce Momjian
> Thomas Lockhart <[EMAIL PROTECTED]> writes: > >> ... I'd be sorely tempted to replace all three by a single > >> function that takes integer and returns numeric. > > > Yikes. Although numeric is theoretically nice, it is hundreds of times > > slower than native doubles. > > (a) As a wise man o

Re: [BUGS] Bug #534: factorial function

2001-12-10 Thread Janko F. Richter
Original Message Subject: Re: [BUGS] Bug #534: factorial function Date: Mon, 10 Dec 2001 13:28:15 +0100 From: "Janko F. Richter" <[EMAIL PROTECTED]> To: Bruce Momjian <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Hallo Bruce, Bruce Mom

Re: [BUGS] Bug #534: factorial function

2001-12-10 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: >> ... I'd be sorely tempted to replace all three by a single >> function that takes integer and returns numeric. > Yikes. Although numeric is theoretically nice, it is hundreds of times > slower than native doubles. (a) As a wise man once said, "I can

Re: [BUGS] Bug #534: factorial function

2001-12-10 Thread Thomas Lockhart
> ... I'd be sorely tempted to replace all three by a single > function that takes integer and returns numeric. Yikes. Although numeric is theoretically nice, it is hundreds of times slower than native doubles. We've already moved it in to some of the other aggregate math functions without much d

Re: [BUGS] Bug #534: factorial function

2001-12-10 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Yep, 0! sure looks like a bug. We will fix it in 7.3. Not sure about > the double precision. Comments? It looks like we have three versions of factorial, for int2 int4 and int8. The version taking int2 is just plain wasted code space (perhaps it pre

Re: [BUGS] Bug #534: factorial function

2001-12-10 Thread Bruce Momjian
Yep, 0! sure looks like a bug. We will fix it in 7.3. Not sure about the double precision. Comments? --- > Janko Richter ([EMAIL PROTECTED]) reports a bug with a severity of 3 > The lower the number the more severe it is

[BUGS] Bug #534: factorial function

2001-12-10 Thread pgsql-bugs
Janko Richter ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description factorial function Long Description 1. The factorial function returns 0 when the argument is 0. The factorial Funtion is defined as: factorial(0)=1 2. It would be