Re: [SQL] Anti log in PostgreSQL

2003-12-27 Thread D'Arcy J.M. Cain
On December 26, 2003 06:37 pm, Tom Lane wrote: > accumulated roundoff in the monetary amounts. I think you will > need to write a little function (in plpgsql or your language of > choice) that performs the sequence of compounding steps, if you > want to get an answer that a banker will like. And

Re: [SQL] Anti log in PostgreSQL

2003-12-27 Thread Chris Travers
Definition of log (base n) is that log n(x) = y where n^y = x for all values of x and y. n is the base. So a base 10 log would be reversed by doing 10^x=y. If we know x, we use the exponential operation; if we know y we use log(y) = x. For ln (natural logs, base e, e is approx. 2.818), use e^x=

Re: [SQL] Anti log in PostgreSQL

2003-12-26 Thread 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 p

Re: [SQL] Anti log in PostgreSQL

2003-12-26 Thread Tom Lane
Sai Hertz And Control Systems <[EMAIL PROTECTED]> writes: >> What is the mathematical operation that "antilog" is supposed to perform? > Its going to calculate rate of intrest for an fixed deposit , This is not a mathematical operation, it is a financial issue that has to conform to rules develo

Re: [SQL] Anti log in PostgreSQL

2003-12-26 Thread Yasir Malik
rom: Martin Marques <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], > Sai Hertz And Control Systems <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [SQL] Anti log in PostgreSQL > i> El Vie 26 Dic 2003 19:12, Sai Hertz And Control

Re: [SQL] Anti log in PostgreSQL

2003-12-26 Thread Sai Hertz And Control Systems
Dear Wei Weng , 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. What is the mathematical operation that "antilog" is supposed to perform? Its going to calculate rate of intrest for an

Re: [SQL] Anti log in PostgreSQL

2003-12-26 Thread Martin Marques
El Vie 26 Dic 2003 19:46, Sai Hertz And Control Systems escribió: > 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)? > >

Re: [SQL] Anti log in PostgreSQL

2003-12-26 Thread Wei Weng
Sai Hertz And Control Systems wrote: 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

Re: [SQL] Anti log in PostgreSQL

2003-12-26 Thread 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.7545558085

Re: [SQL] Anti log in PostgreSQL

2003-12-26 Thread Martin Marques
El Vie 26 Dic 2003 19:12, Sai Hertz And Control Systems escribió: > 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·32

[SQL] Anti log in PostgreSQL

2003-12-26 Thread Sai Hertz And Control Systems
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.