From: | Reinoud van Leeuwen <reinoud(dot)v(at)n(dot)leeuwen(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: POWER vs. POW ??? |
Date: | 2005-11-24 12:06:00 |
Message-ID: | 20051124120600.GS67050@spoetnik.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(dot)v(at)n(dot)leeuwen(dot)net
http://www.xs4all.nl/~reinoud
__________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2005-11-24 12:09:59 | Re: POWER vs. POW ??? |
Previous Message | Christopher Kings-Lynne | 2005-11-24 12:00:21 | POWER vs. POW ??? |