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
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
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 contain one-or-more NaN values. I am used to
using coalesce with
