Re: The "Why Postgres not MySQL" bullet list

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Ian Barwick <barwick(at)gmx(dot)net>
Cc: Postgresql Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: The "Why Postgres not MySQL" bullet list
Date: 2003-08-31 22:29:07
Message-ID: 1062368946.5470.39.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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>.

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Ron Johnson 2003-08-31 22:41:18 Re: About GPL and proprietary software
Previous Message Rod Taylor 2003-08-31 22:13:30 Re: The "Why Postgres not MySQL" bullet list