Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
>>>> I would call those the alternate forms. The canonical (SQL) way is
>>>> -- This is a comment
>> Is this part of the SQL-92 spec?
> This is the *only* comment delimiter defined in the SQL92 spec. The "/*
> .. */" form is present in several database products since a
> block-delimited comment is very useful.
Note that SQL99 added /* ... */ comments.
We are not fully compliant with SQL99's comment specifications, since it
specifies that /* ... */ nest, which is a tad hard to implement in a
finite-state lexer :-(
regards, tom lane
