Re: [SQL] Aggregates with NaN values

2008-12-05 Thread Sean Davis
On Fri, Dec 5, 2008 at 1:51 PM, Mark Roberts <[EMAIL PROTECTED]> wrote: > > On Thu, 2008-12-04 at 13:01 -0500, Sean Davis wrote: >> I am happy to see NaN and infinity handled in input. I would now like >> to compute aggregates (avg, min, max, etc) on columns with NaN values >> in them. The standa

Re: [SQL] Aggregates with NaN values

2008-12-05 Thread Mark Roberts
On Thu, 2008-12-04 at 13:01 -0500, Sean Davis wrote: > I am happy to see NaN and infinity handled in input. I would now like > to compute aggregates (avg, min, max, etc) on columns with NaN values > in them. The standard behavior (it appears) is to have the aggregate > return NaN if the data con