Обсуждение: 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