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