Re: pgsql: Make the behavior of HAVING without GROUP - Mailing list pgsql-committers

From Christopher Kings-Lynne
Subject Re: pgsql: Make the behavior of HAVING without GROUP
Date
Msg-id 4230F431.6040100@familyhealth.com.au
Whole thread Raw
In response to pgsql: Make the behavior of HAVING without GROUP BY conform to the SQL  (tgl@svr1.postgresql.org (Tom Lane))
Responses Re: pgsql: Make the behavior of HAVING without GROUP  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Make the behavior of HAVING without GROUP BY conform to the SQL
Next
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Add: > * Fix cross-compiling of time zone database via 'zic'