List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:October 7 1999 1:27pm
Subject:Re: PostgreSQL vs Mysql comparison
View as plain text  
>>>>> "Bruce" == Bruce Momjian <maillist@stripped> writes:

>> 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*

According to C.J.DATE, A Guide to the SQL standard, forth edition,
page 155, one is allowed in ANSI SQL to use HAVING with any GROUP BY
statement.  One is also allowed to use any scalar functions in the
HAVING part as long as the scalar value is single-value per group.

Where did Thomas/Tom look this up?

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

Should you really give a warning for something that is correct ANSI SQL ?

Regards,
Monty
Thread
PostgreSQL vs Mysql comparisonScott Perkins2 Oct
  • Re: PostgreSQL vs Mysql comparisonPatrick Greenwell2 Oct
    • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker4 Oct
      • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonPaul DuBois4 Oct
        • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker4 Oct
          • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonrandyboy4 Oct
            • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker4 Oct
              • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonBruce Momjian4 Oct
                • Re: PostgreSQL vs Mysql comparisonMartin Ramsch4 Oct
                  • Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker4 Oct
                    • Re: PostgreSQL vs Mysql comparisonTonu Samuel4 Oct
                    • Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
                  • Re: PostgreSQL vs Mysql comparisonBruce Momjian4 Oct
                    • Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
                      • Re: PostgreSQL vs Mysql comparisonBruce Momjian6 Oct
                        • Re: PostgreSQL vs Mysql comparisonMichael Widenius7 Oct
                          • Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker7 Oct
                            • Re: PostgreSQL vs Mysql comparisonBruce Momjian7 Oct
                              • Re: PostgreSQL vs Mysql comparisonMichael Widenius7 Oct
                                • Re: PostgreSQL vs Mysql comparisonMatthias Urlichs7 Oct
                        • Re: [GENERAL] Re: PostgreSQL vs Mysql comparisonAaron J. Seigo7 Oct
                      • Re: PostgreSQL vs MySQL benchmark...Dimitri24 Jul
                  • Re: PostgreSQL vs Mysql comparisonBruce Momjian4 Oct
                    • Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
                      • Re: PostgreSQL vs Mysql comparisonBruce Momjian6 Oct
                • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonPaul DuBois4 Oct
                  • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonBruce Momjian4 Oct
                    • Re: [PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonDuncan Kinder4 Oct
                      • Re: [PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker4 Oct
                        • Re: [PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonDuncan Kinder4 Oct
                    • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
              • PostgreSQL vs Mysql comparisonScott Perkins4 Oct
                • Re: [GENERAL] PostgreSQL vs Mysql comparisonBruce Momjian4 Oct
                • Re: PostgreSQL vs Mysql comparisonLuuk de Boer4 Oct
                • PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
              • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonLuuk de Boer4 Oct
          • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonAaron J. Seigo4 Oct
            • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
              • Re: [PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonRasmus Lerdorf6 Oct
              • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonAaron J. Seigo7 Oct
          • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonLuuk de Boer4 Oct
          • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
            • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker7 Oct
              • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonMichael Widenius7 Oct
          • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonTom Dryden7 Oct
        • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonPatrick Greenwell4 Oct
      • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
    • Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
  • Re: PostgreSQL vs Mysql comparisonJames Manning2 Oct
Re: PostgreSQL vs Mysql comparisonBruce Momjian7 Oct