Skip site navigation (1) Skip section navigation (2)

Re: postgres arithmetic: raising to nth power

From: Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com>
To: nasr(dot)laili(at)tin(dot)it, pgsql-novice(at)postgresql(dot)org
Subject: Re: postgres arithmetic: raising to nth power
Date: 2005-09-29 22:34:45
Message-ID: b356039305092915343fb4c167@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
> Hi all,

> testing a few arithmetic calculations to make sure I understood how
> they worked before including them in a a query I met with the following
> results:
I'm not sure I understand what you're trying to say.


Except for the fact that you encounter rounding errors (which
shouldn't come as a surprise with an exponent of 54) everything
seems to work "normally" as far as I'm concerned.

If you need arbitrary precision don't do the calculation using
a select statement but rather utilise CLN or some other special
maths library.


Cheers,
Andrej

In response to

Responses

pgsql-novice by date

Next:From: Ennio-SrDate: 2005-09-29 23:26:27
Subject: Re: postgres arithmetic: raising to nth power
Previous:From: Tom LaneDate: 2005-09-29 22:27:24
Subject: Re: postgres arithmetic: raising to nth power

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group