WHERE vs HAVING

Поиск
Список
Период
Сортировка
От jwieck@debis.com (Jan Wieck)
Тема WHERE vs HAVING
Дата
Msg-id m10hdA6-000EBbC@orion.SAPserv.Hamburg.dsh.de
обсуждение исходный текст
Ответы Re: [HACKERS] WHERE vs HAVING  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] WHERE vs HAVING  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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@debis.com (Jan Wieck) #

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] backend dies suddenly after a lot of error messages
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] BUG? serials and primary keys (was Re: [INTERFACES] Bug in psql?)