Also, POW() is not documented here:
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