Tom Lane wrote:
Would those of you with access to other DBMSes try this:
create table tab (col integer);
select 1 from tab having 1=0;
select 1 from tab having 1=1;
insert into tab values(1);
insert into tab values(2);
select 1 from tab having 1=0;
select 1 from tab having 1=1;
I claim that a SQL-conformant database will return 0, 1, 0, and 1 rows
MS SQL Server 2000 returns 0, 1, 0 and 1 rows correctly.
Cheers,
Gary.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
