Re: Anti log in PostgreSQL

From: Yasir Malik <ymalik(at)heineken(dot)cs(dot)stevens-tech(dot)edu>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Anti log in PostgreSQL
Date: 2003-12-26 23:18:56
Message-ID: Pine.LNX.4.58.0312261813480.26722@heineken.cs.stevens-tech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

The antilog of x is 10^x, so all you need to do is used the ^ operator.
If you are doing the antilog for some other base, there is formula to do
that as well, but I'm forgetting it.
Regards,
Yasir

On Fri, 26 Dec 2003, Martin Marques wrote:

> Date: Fri, 26 Dec 2003 19:34:35 -0300
> From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
> To: aspire420(at)hotpop(dot)com,
> Sai Hertz And Control Systems <sank89(at)sancharnet(dot)in>,
> pgsql-admin(at)postgresql(dot)org
> Cc: pgsql-sql(at)postgresql(dot)org
> Subject: Re: [SQL] Anti log in PostgreSQL
>
i> 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 (33234) = 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 ^.
>
> --
> select 'mmarques' || '@' || 'unl.edu.ar' AS email;
> -----------------------------------------------------------------
> Martn Marqus | mmarques(at)unl(dot)edu(dot)ar
> Programador, Administrador, DBA | Centro de Telemtica
> Universidad Nacional
> del Litoral
> -----------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Martin Marques 2003-12-26 23:20:23 Re: Anti log in PostgreSQL
Previous Message Wei Weng 2003-12-26 22:53:30 Re: Anti log in PostgreSQL

Browse pgsql-sql by date

  From Date Subject
Next Message Martin Marques 2003-12-26 23:20:23 Re: Anti log in PostgreSQL
Previous Message Wei Weng 2003-12-26 22:53:30 Re: Anti log in PostgreSQL