Re: PostgreSQL vs Mysql comparison - Mailing list pgsql-general

From Bruce Momjian
Subject Re: PostgreSQL vs Mysql comparison
Date
Msg-id 199910070317.XAA29008@candle.pha.pa.us
Whole thread Raw
In response to Re: PostgreSQL vs Mysql comparison  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: PostgreSQL vs Mysql comparison
List pgsql-general
> 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@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: PostgreSQL vs Mysql comparison
Next
From: Frank Mandarino
Date:
Subject: Re: [GENERAL] btree index on a char(8) field (fwd)