bug in (plpgsql) parser?
Reinoud van Leeuwen <reinoud@xs4all.nl>
From: "Reinoud van Leeuwen" <reinoud@xs4all.nl>
To: <pgsql-bugs@postgresql.org>
Date: 2001-05-31T16:01:38Z
Lists: pgsql-bugs
Hello world, I am using "PostgreSQL 7.1.2 on i386-unknown-freebsd4.2, compiled by GCC 2.95.2" (according to version()). I suspect that there is a parser bug in the handling of '--' comments: radius=# create function test() returns integer as ' radius'# begin radius'# -- comment without quotes radius'# return 0; radius'# end; radius'# ' language 'plpgsql'; CREATE This works OK radius=# radius=# create function test2() returns integer as ' radius'# begin radius'# -- comment 'with' quotes radius'# return 0; radius'# end; radius'# ' language 'plpgsql'; ERROR: parser: parse error at or near "with" It seems that the parser does not ignore the rest of the line after the '-- ', as I would suspect... Reinoud van Leeuwen (switched from Sybase to Postgresql two weeks ago and has no regrets! :-)