Anti log in PostgreSQL
Anti log in PostgreSQL
От:
Sai Hertz And Control Systems <sank89@sancharnet.in>
Дата:
Dear all , In one of our project I require to calculate antilog of (3.3234) But I could not find any functions in Documentation for the same. In mathematics I would have written it something like A = antilog (3·3234) = 2144 Any suggestions or links are most welcome . Regards, Vishal Kashyap.
Re: [SQL] Anti log in PostgreSQL
От:
Sai Hertz And Control Systems <sank89@sancharnet.in>
Дата:
Dear Martin Marques , >>In mathematics I would have written it something like >> >>A = antilog (3·3234) = 2144 >> >> > >As I can understand, this is a 10 base log, so that what you want is >10^(3.3234)? > >For that you have the exponential operator ^. > > Nope select exp(3.3234) as a2144 Gives me 27.754555808589792 But the answer expected is some what near to 2144 The log tables show this Regards, Vishal Kashyap.
Re: [SQL] Anti log in PostgreSQL
От:
"David F. Skoll" <dfs@roaringpenguin.com>
Дата:
On Sat, 27 Dec 2003, Sai Hertz And Control Systems wrote: > select exp(3.3234) as a2144 > Gives me > 27.754555808589792 Right. That's e^3.3234 Try: select 10^3.3234; or: select dpow(10, 3.3234); or even: select exp(3.3234 * ln(10.0)); -- David.
Re: [SQL] Anti log in PostgreSQL
От:
Sai Hertz And Control Systems <sank89@sancharnet.in>
Дата:
Dear Martin Marques and other kind people out their , >>In mathematics I would have written it something like >> >>A = antilog (3·3234) = 2144 >> >> > >As I can understand, this is a 10 base log, so that what you want is >10^(3.3234)? > > Though antilog did not solve my problem the link below helped me to prove my point to my bankers http://www.ilovemaths.com/3depreciation.htm http://mathforum.org/dr.math/faq/faq.interest.html Thanks a load for the kind help forwarded by you all. Regards, Vishal Kashyap >For that you have the exponential operator ^. > > >