Re: numeric precision when raising one numeric to

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: claudio(dot)succa(dot)ml(at)pertel(dot)it
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: numeric precision when raising one numeric to
Date: 2005-05-20 19:01:49
Message-ID: 27200.1116615709@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Claudio Succa <claudio(dot)succa(dot)ml(at)pertel(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-05-20 19:17:54 Re: [HACKERS] Inherited constraints and search paths (was Re:
Previous Message Tom Lane 2005-05-20 18:55:53 Re: numeric precision when raising one numeric to another.