Re: psql comment char??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: "Ken J(dot) Wright" <ken(at)ori-ind(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: psql comment char??
Date: 2000-07-03 19:41:56
Message-ID: 20206.962653316@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Byron Nikolaidis 2000-07-04 00:16:14 Re: ODBC and Visual C++
Previous Message Thomas Lockhart 2000-07-03 19:30:31 Re: psql comment char??