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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly