Re: numeric precision when raising one numeric to another. - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: numeric precision when raising one numeric to another.
Date
Msg-id 20050520140408.GA23910@wolff.to
Whole thread Raw
In response to Re: numeric precision when raising one numeric to another.  ("John D. Burger" <john@mitre.org>)
List pgsql-general
On Fri, May 20, 2005 at 08:19:58 -0400,
  "John D. Burger" <john@mitre.org> wrote:
> I find all these statements about the near-uselessness of
> NUMERIC^NUMERIC to be pretty amazing.  It's fine to say, "no one seems
> to be asking for this, so we haven't implemented it yet", but, c'mon,
> folks, Postgres gets used for more than "business cases".

It is pretty useless. If you are doing exact math, fractional exponents
don't fit. If you are using integer exponents, you can store usable
exponents in an int (arguably an an int2).

People may be interested in NUMERIC^NUMERIC MOD N, but if so they aren't
going to do the exponentation first and then the mod operation.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Inherited constraints and search paths (was Re: Preserving data after updates)
Next
From: Stephan Szabo
Date:
Subject: Re: numeric precision when raising one numeric to another.