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

> Tom Lane wrote:
> >
> > Hannu Krosing <hannu(at)tm(dot)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(at)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" test
ERROR: Relation 't1' does not exist

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026