| From: | jwieck(at)debis(dot)com (Jan Wieck) |
|---|---|
| To: | pgsql-hackers(at)postgreSQL(dot)org (PostgreSQL HACKERS) |
| Subject: | WHERE vs HAVING |
| Date: | 1999-05-12 17:51:18 |
| Message-ID: | m10hdA6-000EBbC@orion.SAPserv.Hamburg.dsh.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-05-12 17:53:27 | Re: [HACKERS] BUG? serials and primary keys (was Re: [INTERFACES] Bug in psql?) |
| Previous Message | Tom Lane | 1999-05-12 17:44:01 | Re: [HACKERS] backend dies suddenly after a lot of error messages |