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