Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] We are not following the spec for HAVING without

From: Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: [HACKERS] We are not following the spec for HAVING without
Date: 2005-03-10 19:12:48
Message-ID: 42309C30.7060107@gpdnet.co.uk (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
Tom Lane wrote:
> 
> Would those of you with access to other DBMSes try this:
> 
> create table tab (col integer);
> select 1 from tab having 1=0;
> select 1 from tab having 1=1;
> insert into tab values(1);
> insert into tab values(2);
> select 1 from tab having 1=0;
> select 1 from tab having 1=1;
> 
> I claim that a SQL-conformant database will return 0, 1, 0, and 1 rows

MS SQL Server 2000 returns 0, 1, 0 and 1 rows correctly.

Cheers,
Gary.

In response to

Responses

pgsql-hackers by date

Next:From: Nicolai TufarDate: 2005-03-10 19:22:13
Subject: Re: [pgsql-hackers-win32] snprintf causes regression tests to fail
Previous:From: Barry LindDate: 2005-03-10 18:34:08
Subject: Re: [HACKERS] We are not following the spec for HAVING without GROUP BY

pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-03-10 19:24:41
Subject: Re: [HACKERS] We are not following the spec for HAVING without
Previous:From: Barry LindDate: 2005-03-10 18:34:08
Subject: Re: [HACKERS] We are not following the spec for HAVING without GROUP BY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group