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@bugs.unl.edu.ar>
> To: aspire420@hotpop.com,
> Sai Hertz And Control Systems <sank89@sancharnet.in>,
> pgsql-admin@postgresql.org
> Cc: pgsql-sql@postgresql.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 (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 ^.
>
> --
> select 'mmarques' || '@' || 'unl.edu.ar' AS email;
> -----------------------------------------------------------------
> Mart�n Marqu�s | mmarques@unl.edu.ar
> Programador, Administrador, DBA | Centro de Telem�tica
> Universidad Nacional
> del Litoral
> -----------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>