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 [EMAIL PROTECTED] http://www.xs4all.nl/~reinoud __________________________________________________ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
