Re: We are not following the spec for HAVING without GROUP

From: Mark Shewmaker <mark(at)primefactor(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: We are not following the spec for HAVING without GROUP
Date: 2005-03-10 05:20:06
Message-ID: 1110432006.12946.2.camel@k9
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Wed, 2005-03-09 at 21:21 -0500, Tom Lane wrote:
> Comments? Can anyone confirm whether DB2 or other databases allow
> ungrouped column references with HAVING?

In Sybase:

1> select 2 as id, max(myfield) from mytable where 2=1
2> go
id
----------- ----------
2 NULL

(1 row affected)
1> select 2 as id, max(myfield) from mytable having 2=1
2> go
id
----------- ----------

(0 rows affected)

--
Mark Shewmaker
mark(at)primefactor(dot)com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Burn ! 2005-03-10 08:43:58 R: Fault when return strings over 256 characters in PLpgSQL
Previous Message Tom Lane 2005-03-10 05:06:24 Re: We are not following the spec for HAVING without GROUP BY

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-03-10 05:25:02 Re: Information schema tweak?
Previous Message Tom Lane 2005-03-10 05:09:54 Re: Information schema tweak?