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))
Ответы Re: pgsql: Make the behavior of HAVING without GROUP
Список pgsql-committers
Дерево обсуждения 
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)
Дата:
Сообщение: pgsql: Make the behavior of HAVING without GROUP BY conform to the SQL
Следующее
От: momjian@svr1.postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Add: > * Fix cross-compiling of time zone database via 'zic'