Exponantial Function (exp) with bigger argument ?

From: "Gregor GT(dot) Trefs" <gregor(dot)trefs(at)delphit(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Exponantial Function (exp) with bigger argument ?
Date: 2011-05-03 16:28:05
Message-ID: 5987F6572432A3439988CDF27C6239A6F18A90073D@winserver.delphit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

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 ? Currently, I try to shift a data related part of our business logic into the database to save some computation time. Unfortunately, this involves the exponential function with arguments which become bigger than 100. I had a look on the pgmp extension, but it seems it does not provide any exponential function. In our ruby project we are using the mpc and mpfr modules which are linked to the corresponding c-libraries. Would be recompilation of Postgres with mpc/mpfr work ? If yes, how would I do this ? Is there any ready-to-use extension which enables me to use the provided types of mpc and mpfr ? If yes, where can I find them ? Is there any other solution to my problem, which I did not thought of ?

I'm looking forward to your answers,

Regards,

Gregor

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sébastien D'Errico 2011-05-03 16:33:16 Re: create a database with encoding LATIN1
Previous Message Peter Geoghegan 2011-05-03 16:07:50 Re: [ADMIN] Can we Flush the Postgres Shared Memory ?