Re: [HACKERS] Re: SQL compliance - why -- comments only at psql level ? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Re: SQL compliance - why -- comments only at psql level ?
Date
Msg-id 200002190138.UAA23190@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Re: SQL compliance - why -- comments only at psql level ?  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
> Tom Lane wrote:
> > 
> > Hannu Krosing <hannu@tm.ee> writes:
> > > Thomas Lockhart wrote:
> > >> ... although InterBase was lauded for SQL92 compliance, the author
> > >> did encourage them to consider supporting the SQL92 comment delimiter
> > >> ("--") in their next release :))
> > 
> > > Why does PostgreSQL _not_ support the -- comment delimiter ?
> > 
> > Better read it again, Hannu ... wasn't us that was being spoken of ...
> 
> I got the impression from the paragraph that followed that we don't
> 
> and the first query I tried bounced from commandline
> 
> [hannu@hu hannu]$ psql -c "select count(*) from t1 -- what"
> ERROR:  parser: parse error at or near "-"

Worked here:
$ sql -c "select count(*) from t1 -- what" testERROR:  Relation 't1' does not exist


--  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,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] Re: SQL compliance - why -- comments only at psql level ?
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Re: SQL compliance - why -- comments only at psql level ?