Re: Exponantial Function (exp) with bigger argument ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gregor GT(dot) Trefs" <gregor(dot)trefs(at)delphit(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Exponantial Function (exp) with bigger argument ?
Date: 2011-05-03 18:01:04
Message-ID: 23172.1304445664@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Gregor GT. Trefs" <gregor(dot)trefs(at)delphit(dot)com> writes:
> Is there any possibility to overcome the restriction to not use a
> higher number than appr. 100 as an argument for the exponential
> function in postgres ?

What restriction?

regression=# select exp(1000.0);
exp
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
197007112172228764285408431116443651047300981094802008755853985828350443654498948052236544085754035611119684706809582853182955874910502440327439392806215139501177952207939837125875818468684009900351395991300432715505235653014871192637790968152087501139107799418773107714238073871162818125586289629983090134192022542188366296411429692950563401460360277794420292466575635467954804734395417151344955106563797211636884598324669752528955502.2
(1 row)

Mind you, it would be unwise to assume that that answer is *exact*
... exactly what is the "business logic" that requires such large
exponentials, and are you sure you're getting non-garbage results on any
other platform?

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Grzegorz Szpetkowski 2011-05-03 18:21:43 Re: create a database with encoding LATIN1
Previous Message Grzegorz Szpetkowski 2011-05-03 17:35:25 Re: create a database with encoding LATIN1