Horton

Re: [HACKERS] WHERE vs HAVING

Bruce Momjian <maillist@candle.pha.pa.us>

View thread
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Jan Wieck <jwieck@debis.com>
Cc: PostgreSQL HACKERS <pgsql-hackers@postgreSQL.org>
Date: 1999-07-07T03:40:33Z
Lists: pgsql-hackers 
>     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, Pennsylvania 19026