Re: Optimizing maximum/minimum queries (yet again)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Optimizing maximum/minimum queries (yet again)
Date: 2005-04-09 03:37:53
Message-ID: 18864.1113017873@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> 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?

We only intend this to support MAX and MIN. If you're inventing an
aggregate that doesn't play exactly by those rules, you don't get to
take advantage of the optimization.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-04-09 03:40:28 Re: Optimizing maximum/minimum queries (yet again)
Previous Message Tom Lane 2005-04-09 03:36:15 Re: Optimizing maximum/minimum queries (yet again)