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

From Tom Lane
Subject Re: numeric precision when raising one numeric to another.
Date
Msg-id 25606.1116452548@sss.pgh.pa.us
Whole thread Raw
In response to numeric precision when raising one numeric to another.  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: numeric precision when raising one numeric to
Re: numeric precision when raising one numeric to another.
List pgsql-general
Scott Marlowe <smarlowe@g2switchworks.com> writes:
> It appears from checking the output of exponentiation of one numeric to
> another, the output is actually in floating point.  Is this normal and /
> or expected?

Yes, seeing that the only ^ operator we have is float8.

regression=# \do ^
                                         List of operators
   Schema   | Name |  Left arg type   |  Right arg type  |   Result type    |
  Description
------------+------+------------------+------------------+------------------+----------------------
 pg_catalog | ^    | double precision | double precision | double precision | exponentiation (x^y)
(1 row)

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Image storage questions
Next
From: Scott Marlowe
Date:
Subject: Re: numeric precision when raising one numeric to