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

On Thu, 10 Mar 2005 12:44:50 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Would those of you with access to other DBMSes try this:
> 
On informix 9.21.UC4

> create table tab (col integer);
> select 1 from tab having 1=0;
>
returns no rows

> select 1 from tab having 1=1;
>
returns no rows

> insert into tab values(1);
> insert into tab values(2);
> select 1 from tab having 1=0;
> 
returns no rows

> select 1 from tab having 1=1;
> 
returns 2 rows

regards, 
Jaime Casanova