Results from Oracle 9.2.0.3 (9.2 patch 2)
===========
Connected to Oracle9i Release 9.2.0.3.0
Connected as system
SQL>
SQL> DROP TABLE TESTTAB;
DROP TABLE TESTTAB
ORA-00942: table or view does not exist
SQL> create table TESTtab (col integer);
Table created
SQL> select 1 as col from TESTtab having 1=0;
COL
----------
SQL> select 1 as col from TESTtab having 1=1;
COL
----------
SQL> insert into TESTtab values(1);
1 row inserted
SQL> insert into TESTtab values(2);
1 row inserted
SQL> select 1 as col from TESTtab having 1=0;
COL
----------
SQL> select 1 as col from TESTtab having 1=1;
COL
----------
1
1
SQL> DROP TABLE TESTTAB;
Table dropped
SQL>
===========
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
