Re: POWER vs. POW ???

On Thu, Nov 24, 2005 at 08:00:21PM +0800, 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.)

The result field is the length of min(the string, printable result) + 2:

# SELECT POW(2,-2);pow
------0.25
(1 row)

# SELECT POW(2,-2) as power;power
------- 0.25
(1 row)

# SELECT POW(2,-2) as p; p
------0.25
(1 row)

-- 
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://www.xs4all.nl/~reinoud
__________________________________________________