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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073