Re: Optimizing maximum/minimum queries (yet again)

On Fri, Apr 08, 2005 at 20:50:09 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
> Comments?  Anyone see anything I missed?

Thinking about the case for NULLs some more, I am wondering if you are
going to treat aggregates with strict state functions different than
those that don't? It seems for ones with strict state functions you need
to not include NULL values when doing using ORDER BY. For aggregates
that aren't strict it may be possible that it is desired that NULL
be returned if there is a NULL value in one of the rows.