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

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@primefactor.com