| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | Mark Kirkwood <markir(at)coretech(dot)co(dot)nz> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] We are not following the spec for HAVING without GROUP |
| Date: | 2005-03-14 12:40:38 |
| Message-ID: | 1h1b31d9if4586q25g19iobm43e89sn6nq@email.aon.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Fri, 11 Mar 2005 10:37:13 +1300, Mark Kirkwood
<markir(at)coretech(dot)co(dot)nz> wrote:
>Firebird 1.5.1 FreeBSD 5.3
>[correct results]
Interbase 6.0:
SQL> create table tab (col integer);
SQL> select 1 from tab having 1=0;
SQL> select 1 from tab having 1=1;
============
0 <------- :-)
SQL> insert into tab values(1);
SQL> insert into tab values(2);
SQL> select 1 from tab having 1=0;
SQL> select 1 from tab having 1=1;
============
1
SQL>
Servus
Manfred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavlo Zhezhnych | 2005-03-14 12:43:50 | BUG #1544: Problems with ODBC |
| Previous Message | Michael Fuhr | 2005-03-14 11:58:05 | Re: BUG #1537: alter table statement |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Bjorklund | 2005-03-14 12:59:45 | Re: [BUGS] We are not following the spec for HAVING without |
| Previous Message | pgsql | 2005-03-14 12:38:20 | Re: signed short fd |