public inbox for [email protected]  
help / color / mirror / Atom feed
docs correction (8.0 beta)
5+ messages / 3 participants
[nested] [flat]

* docs correction (8.0 beta)
@ 2004-08-19 18:17  John DeSoi <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: John DeSoi @ 2004-08-19 18:17 UTC (permalink / raw)
  To: pgsql-docs

 From the example below and looking at scan.c, it seems that nested 
block comments are supported.

test=# select /* /* nested */ */ 1;
  ?column?
----------
         1
(1 row)



 From section 35.3:

There are two types of comments in PL/pgSQL. A double  dash (--) starts 
a comment that extends to the end of  the line. A /* starts a block 
comment that extends to  the next occurrence of */. Block comments 
cannot be  nested, but double dash comments can be enclosed into a 
block comment and  a double dash can hide the block comment delimiters 
/*  and */.




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: docs correction (8.0 beta)
@ 2004-08-24 20:06  Tom Lane <[email protected]>
  parent: John DeSoi <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Tom Lane @ 2004-08-24 20:06 UTC (permalink / raw)
  To: John DeSoi <[email protected]>; +Cc: pgsql-docs

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.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: docs correction (8.0 beta)
@ 2004-08-25 19:55  Bruce Momjian <[email protected]>
  parent: Tom Lane <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Bruce Momjian @ 2004-08-25 19:55 UTC (permalink / raw)
  To: Tom Lane <[email protected]>; +Cc: John DeSoi <[email protected]>; pgsql-docs

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: docs correction (8.0 beta)
@ 2004-08-25 20:01  Tom Lane <[email protected]>
  parent: Bruce Momjian <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Tom Lane @ 2004-08-25 20:01 UTC (permalink / raw)
  To: Bruce Momjian <[email protected]>; +Cc: John DeSoi <[email protected]>; pgsql-docs

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: docs correction (8.0 beta)
@ 2004-08-25 20:06  Bruce Momjian <[email protected]>
  parent: Tom Lane <[email protected]>
  0 siblings, 0 replies; 5+ messages in thread

From: Bruce Momjian @ 2004-08-25 20:06 UTC (permalink / raw)
  To: Tom Lane <[email protected]>; +Cc: John DeSoi <[email protected]>; pgsql-docs

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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2004-08-25 20:06 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-19 18:17 docs correction (8.0 beta) John DeSoi <[email protected]>
2004-08-24 20:06 ` Tom Lane <[email protected]>
2004-08-25 19:55   ` Bruce Momjian <[email protected]>
2004-08-25 20:01     ` Tom Lane <[email protected]>
2004-08-25 20:06       ` Bruce Momjian <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox