> Next question is should we emit a NOTICE or just silently do it?
> (For that matter, should we go so far as to push the HAVING condition
> over to become part of WHERE when it has no agg? Then the speed issue
> goes away.) I kind of like emitting a NOTICE on the grounds of helping
> to educate users about the difference between WHERE and HAVING, but
> maybe people would just see it as obnoxious.
That is a tough call. My personal vote is that HAVING is misunderstood
enough to emit a warning.
-- 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