Re: The "Why Postgres not MySQL" bullet list

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: The "Why Postgres not MySQL" bullet list
Дата
Msg-id 1062368946.5470.39.camel@jester
обсуждение исходный текст
Ответ на Re: The "Why Postgres not MySQL" bullet list  (Ian Barwick <barwick@gmx.net>)
Ответы Re: The "Why Postgres not MySQL" bullet list  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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>.

Вложения

В списке pgsql-advocacy по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: The "Why Postgres not MySQL" bullet list
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: The "Why Postgres not MySQL" bullet list