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, Pennsylvania 19026Import Notes
Reply to msg id not found: 00031716011301.00436@zeus
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
Show quoted text
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, Pennsylvania 19026