From: | Terry Yapt <yapt(at)NOtechSAPMnovell(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: We are not following the spec for HAVING without GROUP |
Date: | 2005-03-11 13:37:37 |
Message-ID: | sj73311bugnc7r9vkvp43kjnukmgphs4su@4ax.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs 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>
===========
From | Date | Subject | |
---|---|---|---|
Next Message | Sergio Lob | 2005-03-11 14:56:35 | Re: [BUGS] BUG #1523: precision column value returned from |
Previous Message | Ludwig Lim | 2005-03-11 12:55:06 | BUG #1538: Unable to reattach to shared memory |
From | Date | Subject | |
---|---|---|---|
Next Message | Ioannis Theoharis | 2005-03-11 14:16:58 | Explain Analyze mode |
Previous Message | Ioannis Theoharis | 2005-03-11 13:23:27 | Re: Raw size |