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 NULL values, but that doesn't work with NaN. I can deal with these using CASE statuement to assign a value, but is there a standard way of dealing with the NaN (or Infinity, for that matter) cases to get a behvavior where they are "ignored" by an aggregate?
Thanks, Sean -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
