Re: We are not following the spec for HAVING without GROUP - Mailing list pgsql-hackers

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> 
===========