Re: [HACKERS] Re: SQL compliance - why -- comments only at psql level ?

> 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