X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D853AD1B450 for ; Fri, 26 Dec 2003 23:21:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57167-01 for ; Fri, 26 Dec 2003 19:20:22 -0400 (AST) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id AC083D1B471 for ; Fri, 26 Dec 2003 19:20:19 -0400 (AST) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) id <0HQI00301ZHM1N@ndl1mr1-a-fixed.sancharnet.in> for pgsql-sql@postgresql.org; Sat, 27 Dec 2003 04:50:21 +0530 (IST) Received: from sancharnet.in ([61.0.95.112]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HQI001TMZH7LO@ndl1mr1-a-fixed.sancharnet.in>; Sat, 27 Dec 2003 04:50:21 +0530 (IST) Date: Sat, 27 Dec 2003 04:55:11 +0530 From: Sai Hertz And Control Systems Subject: Re: Anti log in PostgreSQL In-reply-to: <3FECBBEA.5080100@kencast.com> To: Wei Weng Cc: aspire420@hotpop.com, Martin Marques , pgsql-sql@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <3FECC357.6040206@sancharnet.in> Organization: Sai Hertz And Control Systems MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 References: <3FECB238.1050801@sancharnet.in> <200312261934.35070.martin@bugs.unl.edu.ar> <3FECBA50.2000500@sancharnet.in> <3FECBBEA.5080100@kencast.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/187 X-Sequence-Number: 16353 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 fixed deposit , Iknow theirs other metod also bu theoratically using antilog you get calculations bang corect This is inverse of log Now doing select 1/log(3.3234) does not help _________________ Vishal Kashyap