WHERE vs HAVING

Planner guru's please!

    I  wonder  what makes the difference between WHERE and HAVING
    that causes HAVING to accept aggregates while WHERE  doesn't.
    It  would  be  extremely nice if it's possible to teach WHERE
    how to handle aggregates properly. Having to push  them  into
    subselects during rewrite if a views aggregate column appears
    in the WHERE clause is a total mess.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #