Re: The "Why Postgres not MySQL" bullet list - Mailing list pgsql-advocacy

> > Would you like a hand in tracing down quotes where spec in these areas?
>
> Yup. I'm interested in facts not FUD ;-).

-- style comments

Notice that there is nothing mentioned in section 5.2 about an
alternative to treating --[{-}...] as a comment.

        Side note:
        A PostgreSQL gotcha includes nested block comments /* */, which
        the spec does not support. Consider:

        SELECT 'TEST' || /* My field goes with this "/*" */ '*/';

        PostgreSQL believes the '; to be part of a string.  Spec says
        this is a complete statement.


Section 5.2

Format:

<simple comment> ::= <simple comment introducer> [ <comment
character>... ] <newline>

<simple comment introducer> ::= <minus sign><minus sign>[<minus
sign>...]
<comment character> ::= <nonquote character> | <quote>


Syntax Rules:

18) SQL text containing one or more instances of <comment> is equivalent
to the same SQL text with the <comment> replaced with <newline>.