Re: [DOCS] docs correction (8.0 beta)

2004-08-25 Thread Bruce Momjian 
Tom Lane wrote:
> John DeSoi <[EMAIL PROTECTED]> writes:
> >  From the example below and looking at scan.c, it seems that nested 
> > block comments are supported.
> 
> You are confusing SQL and PL/pgSQL.

Any idea why they don't match between SQL and PL/pgSQL.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [DOCS] docs correction (8.0 beta)

2004-08-25 Thread Tom Lane 
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> You are confusing SQL and PL/pgSQL.

> Any idea why they don't match between SQL and PL/pgSQL.

Different lexers.

We could talk about extending plpgsql's lexer to handle comments the
same way as the main SQL lexer, but it doesn't do so ATM.  (Also, there
is compatibility with Oracle PL/SQL to think about before assuming such
a change must be a Good Thing...)

regards, tom lane

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

Re: [DOCS] docs correction (8.0 beta)

2004-08-25 Thread Bruce Momjian 
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> You are confusing SQL and PL/pgSQL.
> 
> > Any idea why they don't match between SQL and PL/pgSQL.
> 
> Different lexers.
> 
> We could talk about extending plpgsql's lexer to handle comments the
> same way as the main SQL lexer, but it doesn't do so ATM.  (Also, there
> is compatibility with Oracle PL/SQL to think about before assuming such
> a change must be a Good Thing...)

Yea, I was wondering about PL/SQL compatibility.  Someone want to
research that?

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 8: explain analyze is your friend