Thread: 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