Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: numeric precision when raising one numeric to
Date
Msg-id 27200.1116615709@sss.pgh.pa.us
Whole thread Raw
In response to Re: numeric precision when raising one numeric to  (Claudio Succa <claudio.succa.ml@pertel.it>)
List pgsql-general
Tree view 
Claudio Succa <claudio.succa.ml@pertel.it> writes:
> With PostgreSQL 7.4.7 on Linux/Debian platform I had a different result so I
> made the subtraction of your figure:
> psql -h s1 -d rapp-test -c "select power(2::numeric,1000) -

I don't know what you're getting there, but there is no power() function
at all in a standard 7.4 installation.  Possibly you have a homebrew
function that uses the floating-point dpow() code?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: numeric precision when raising one numeric to another.
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Inherited constraints and search paths (was Re: