[GENERAL] round returns -0

2013-03-06 Thread Tony Dare
I'm taking an standard deviation of a population and subtracting it from the average of the same population and rounding the result. Sometimes that result is negative and rounding it returns (or shows up as) a negative zero (-0) in a SELECT. basically: SELECT client_name, avg(rpt_cnt), std

Re: [GENERAL] round returns -0

2013-03-08 Thread Tony Dare
On 03/06/2013 07:16 PM, François Beausoleil wrote: Le 2013-03-06 à 21:42, Tony Dare a écrit : I'm taking an standard deviation of a population and subtracting it from the average of the same population and rounding the result. Sometimes that result is negative and rounding it return

Re: [GENERAL] Running out of memory at vacuum

2013-05-16 Thread Tony Dare
On 05/16/2013 07:13 AM, Ioana Danes wrote: Hi Jeff, Yes stop/start of the application server does close all the connections to the database. Lately I did restart postgres too everytime that happened. It did happen in the past, last year sometime when I tried just to close the app and it was n