Re: POWER vs. POW ???

Christopher Kings-Lynne wrote:
> Also, POW() is not documented here:

I think POW is just there for backward compatibility and people should
use POWER().

---------------------------------------------------------------------------

>
> http://www.postgresql.org/docs/8.1/interactive/functions-math.html
>
> Chris
>
> Christopher Kings-Lynne wrote:
> > How come these give slightly different results?
> >
> > test=# SELECT POW(2,-2);
> > pow
> > ------
> > 0.25
> > (1 row)
> >
> > test=# SELECT POWER(2,-2);
> > power
> > -------
> > 0.25
> > (1 row)
> >
> >
> > (Note width of result field.)
> >
> > Chris
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073