On Thu, 10 Mar 2005 12:44:50 -0500, Tom Lane <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
