Skip site navigation (1) Skip section navigation (2)

Re: The "Why Postgres not MySQL" bullet list

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: Ian Barwick <barwick(at)gmx(dot)net>,Postgresql Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: The "Why Postgres not MySQL" bullet list
Date: 2003-09-01 02:02:38
Message-ID: 200309010202.h8122cA26821@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-advocacy
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

In response to

Responses

pgsql-advocacy by date

Next:From: Christopher BrowneDate: 2003-09-01 02:06:13
Subject: Re: About GPL and proprietary software
Previous:From: Bruce MomjianDate: 2003-08-31 23:37:47
Subject: Re: About GPL and proprietary software

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group