Re: The "Why Postgres not MySQL" bullet list

Rod Taylor wrote:
-- Start of PGP signed section.
> > > 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>.

I thought a newer SQL spec allows C comments --- am I remembering
correctly?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073