Re: numeric precision when raising one numeric to

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