From: Date: October 7 1999 5:17am
Subject: Re: PostgreSQL vs Mysql comparison
List-Archive: http://lists.mysql.com/mysql/15391
Message-Id: <199910070317.XAA29008@candle.pha.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

> On Thu, 7 Oct 1999, Michael Widenius wrote:
> 
> > As you may have seen on the postgreSQL list, crash-me was actually
> > right that postgreSQL didn't support -- comments and HAVING as
> > required by ANSI SQL.  Isn't it nice that we help you fix your bugs?
> 
> Actually, I believe Thomas did research on this point (or was it Tom?) and
> determined that HAVING w/o aggregates is *not* required by ANSI SQL ...
> could out point out where this requirement is listed? *raised eyebrow*

Seems we will downgrade it to a warning.  Too many people misunderstand
HAVING vs. WHERE, so a nice warning would help new users.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@stripped            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026