X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3DB6DD1B465; Fri, 26 Dec 2003 22:42:28 +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 50619-06; Fri, 26 Dec 2003 18:41:40 -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 A9914D1B478; Fri, 26 Dec 2003 18:41:37 -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 <0HQI00201XJFJW@ndl1mr1-a-fixed.sancharnet.in>; Sat, 27 Dec 2003 04:11:39 +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 <0HQI001R7XOZLO@ndl1mr1-a-fixed.sancharnet.in>; Sat, 27 Dec 2003 04:11:39 +0530 (IST) Date: Sat, 27 Dec 2003 04:16:40 +0530 From: Sai Hertz And Control Systems Subject: Re: [SQL] Anti log in PostgreSQL In-reply-to: <200312261934.35070.martin@bugs.unl.edu.ar> To: Martin Marques Cc: aspire420@hotpop.com, pgsql-admin@postgresql.org, pgsql-sql@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <3FECBA50.2000500@sancharnet.in> Organization: Sai Hertz And Control Systems MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 8BIT 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> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.4 tagged_above=0.0 required=5.0 tests=BAYES_30, FROM_ENDS_IN_NUMS, IN_REP_TO, RCVD_IN_RFCI, REFERENCES, USER_AGENT_MOZILLA_UA X-Spam-Level: X-Archive-Number: 200312/314 X-Sequence-Number: 11820 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.