Обсуждение: psql comment char??
Sorry for this Q, but I only subscribe to interfaces list... Is there a comment char/symbol for psql to allow me to annotate files that I suck in with \i ???? I haven't stumbled on one so for, nor can i find reference to one in the documentation... thanks, Mark Dzmura -- )))) This email routed via a wireless gateway!! ((((
Вложения
/* this is a comment */ /* this is also a comment */ There is also an alternate form, but I can't remember it. Cheers! Ken On Thu, 29 Jun 2000, Mark Dzmura wrote: > >%_Sorry for this Q, but I only subscribe to interfaces list... > > Is there a comment char/symbol for psql to allow me to annotate files that > I suck in with \i ???? I haven't stumbled on one so for, nor can i find > reference to one in the documentation... > > thanks, > Mark Dzmura > > -- > )))) This email routed via a wireless gateway!! (((( > > > ---------------------------------------- Content-Type: text/x-vcard; name="mdz.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Mark Dzmura ----------------------------------------
Thus spake Ken J. Wright
> /* this is a comment */
> /* this is
> also
> a
> comment
> */
>
> There is also an alternate form, but I can't remember it.
I would call those the alternate forms. The canonical (SQL) way is
-- This is a comment
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
> I would call those the alternate forms. The canonical (SQL) way is > > -- This is a comment Is this part of the SQL-92 spec?
> > 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.
- Thomas
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
Mark Dzmura wrote: > Sorry for this Q, but I only subscribe to interfaces list... > > Is there a comment char/symbol for psql to allow me to annotate files that > I suck in with \i ???? I haven't stumbled on one so for, nor can i find > reference to one in the documentation... Either -- at start of comment portion (continues to EOL) or /* */ for comment block -ala C. > > > thanks, > Mark Dzmura Grant -- > Poorly planned software requires a genius to write it > and a hero to use it. Grant Finnemore BSc(Eng) (mailto:gaf@ucs.co.za) Software Engineer Universal Computer Services Tel (+27)(11)712-1366 PO Box 31266 Braamfontein 2017, South Africa Cell (+27)(82)604-5536 20th Floor, 209 Smit St., Braamfontein Fax (+27)(11)339-3421 Johannesburg, South Africa
On Thu, 29 Jun 2000, Mark Dzmura wrote: > Is there a comment char/symbol for psql to allow me to annotate files that > I suck in with \i ???? I haven't stumbled on one so for, nor can i find > reference to one in the documentation... The normal SQL comment characters: -- (until end of line) /* ... */ -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden