Thread: pgsql: Department of second thoughts: the rule that ORDER BY and

pgsql: Department of second thoughts: the rule that ORDER BY and

From

tgl@postgresql.org (Tom Lane)

Date:

28 March 2008, 02:00:17

Log Message:
-----------
Department of second thoughts: the rule that ORDER BY and DISTINCT are
useless for an ungrouped-aggregate query holds regardless of whether
optimize_minmax_aggregates succeeds.  So we might as well apply the
optimization in any case.

I'll leave 8.3 as it was, since this version is a tad more invasive
than my earlier patch.

Modified Files:
--------------
    pgsql/src/backend/optimizer/plan:
        planner.c (r1.228 -> r1.229)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c?r1=1.228&r2=1.229)