Обсуждение: Re: FORMAL VOTE ON =- and similar

Can someone comment on this?  Add to TODO?


> On Fri, 17 Mar 2000, Thomas Lockhart wrote:
> >Actually, I'd suggest we *remove* the "//" comment delimiters
> >altogether. We always had the "--" SQL92 delimiter, I added the "/*
> >... */" so we could get a block delimiter of some sort (it is the same
> >aas in Ingres). I don't know what other DBMSes do, and we could define
> >something else instead if SQL3 or some other convention offers a
> >strong reason.
> 
> I think the standard specifies the curly brackets as comment block characters.
> I checked, and we do not have them :-( 
> 
> Example:
> select { this is a comment } * from pg_class;
> 
> Most (all that I know) other DB's have them.
> 
> Andreas
> 


--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Can someone comment on this?  Add to TODO?

Last I checked, SQL3 specifies -- and /*...*/ and nothing else.
I think we are in good shape on the comment front.
        regards, tom lane


>> On Fri, 17 Mar 2000, Thomas Lockhart wrote:
>>>> Actually, I'd suggest we *remove* the "//" comment delimiters
>>>> altogether. We always had the "--" SQL92 delimiter, I added the "/*
>>>> ... */" so we could get a block delimiter of some sort (it is the same
>>>> aas in Ingres). I don't know what other DBMSes do, and we could define
>>>> something else instead if SQL3 or some other convention offers a
>>>> strong reason.
>> 
>> I think the standard specifies the curly brackets as comment block characters.
>> I checked, and we do not have them :-( 
>> 
>> Example:
>> select { this is a comment } * from pg_class;
>> 
>> Most (all that I know) other DB's have them.
>> 
>> Andreas
>> 


> -- 
>   Bruce Momjian                        |  http://www.op.net/~candle
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

> Can someone comment on this?  Add to TODO?

No.

> > On Fri, 17 Mar 2000, Thomas Lockhart wrote:
> > >Actually, I'd suggest we *remove* the "//" comment delimiters
> > >altogether. We always had the "--" SQL92 delimiter, I added the "/*
> > >... */" so we could get a block delimiter of some sort (it is the same
> > >aas in Ingres). I don't know what other DBMSes do, and we could define
> > >something else instead if SQL3 or some other convention offers a
> > >strong reason.
> > 
> > I think the standard specifies the curly brackets as comment block characters.

wrong, I'm sorry for the misinformation.

> > I checked, and we do not have them :-( 
> > 
> > Example:
> > select { this is a comment } * from pg_class;
> > 
> > Most (all that I know) other DB's have them

It turns out I was always beleiving it to be so, but it isn't. 
The {} are an Informix'ism and thus not worth implementing.

Andreas

> > > Example:
> > > select { this is a comment } * from pg_class;
> > > 
> > > Most (all that I know) other DB's have them
> 
> It turns out I was always beleiving it to be so, but it isn't. 
> The {} are an Informix'ism and thus not worth implementing.

Yes, I have seen it on Informix.


--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026