[SQL] Anti log in PostgreSQL

[Sai Hertz And Control Systems]

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.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[David F. Skoll]

Post by Sai Hertz And Control Systems
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.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Sai Hertz And Control Systems]

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 ^.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org