> 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.
SQL requires the restriction.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026