| From: | johnnnnnn <john(at)phaedrusdeinus(dot)org> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: [HACKERS] We are not following the spec for HAVING without GROUP BY |
| Date: | 2005-03-10 20:01:28 |
| Message-ID: | 20050310200128.GA32629@performics.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Thu, Mar 10, 2005 at 12:44:50PM -0500, Tom Lane wrote:
> Would those of you with access to other DBMSes try this:
DB2/LINUX 8.1.6
> create table tab (col integer);
> select 1 from tab having 1=0;
1
-----------
0 record(s) selected.
> select 1 from tab having 1=1;
1
-----------
1
1 record(s) selected.
> insert into tab values(1);
> insert into tab values(2);
> select 1 from tab having 1=0;
1
-----------
0 record(s) selected.
> select 1 from tab having 1=1;
1
-----------
1
1 record(s) selected.
-johnnnnnnnn
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2005-03-10 20:14:23 | Re: We are not following the spec for HAVING without GROUP BY |
| Previous Message | Michael Fuhr | 2005-03-10 19:24:41 | Re: [HACKERS] We are not following the spec for HAVING without |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2005-03-10 20:14:23 | Re: We are not following the spec for HAVING without GROUP BY |
| Previous Message | Kris Kiger | 2005-03-10 19:57:30 | Re: Functions and transactions |