Re: numeric precision when raising one numeric to

[Tom Lane <tgl@xxxxxxxxxxxxx>]

Claudio Succa <claudio.succa.ml@xxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq