Re: pgsql: Make the behavior of HAVING without GROUP

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
Re: pgsql: Make the behavior of HAVING without GROUP
Дата
Msg-id
4230F431.6040100@familyhealth.com.au
Ответ на
pgsql: Make the behavior of HAVING without GROUP BY conform to the SQL (tgl@svr1.postgresql.org (Tom Lane))
Список
Дерево обсуждения
pgsql: Make the behavior of HAVING without GROUP BY conform to the SQL tgl@svr1.postgresql.org (Tom Lane)
Re: pgsql: Make the behavior of HAVING without GROUP Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: pgsql: Make the behavior of HAVING without GROUP Tom Lane <tgl@sss.pgh.pa.us> 
I wonder how much back-compatibility and dump reloading problems this 
might cause? :(

Tom Lane wrote:
> Log Message:
> -----------
> Make the behavior of HAVING without GROUP BY conform to the SQL spec.
> Formerly, if such a clause contained no aggregate functions we mistakenly
> treated it as equivalent to WHERE.  Per spec it must cause the query to
> be treated as a grouped query of a single group, the same as appearance
> of aggregate functions would do.  Also, the HAVING filter must execute
> after aggregate function computation even if it itself contains no
> aggregate functions.
В списке pgsql-committers по дате отправления
Предыдущее
От: tgl@svr1.postgresql.org (Tom Lane)
Дата:
Следующее
От: momjian@svr1.postgresql.org (Bruce Momjian)
Дата:
FAQ