Re: numeric precision when raising one numeric to another.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: numeric precision when raising one numeric to another.
Date: 2005-05-18 21:53:08
Message-ID: 25769.1116453188@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

Scott Marlowe <smarlowe(at)g2switchworks(dot)com> writes:
> Considering that the SQL spec says the result of multiplication of exact
> numeric types is exact numeric types of precision S1+S2, and
> exponentiation is nothing more than repeated multiplication,

... not when the exponent is non-integral.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Noel 2005-05-18 22:49:24 Re: Image storage questions
Previous Message Scott Marlowe 2005-05-18 21:46:38 Re: numeric precision when raising one numeric to

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-05-18 22:16:37 Re: Refactoring in lock.c
Previous Message Scott Marlowe 2005-05-18 21:46:38 Re: numeric precision when raising one numeric to