does parser still parse those comment out lines?

From: Weiping He <laser(at)zhengmai(dot)com(dot)cn>
To: pgsql-bugs(at)postgresql(dot)org
Subject: does parser still parse those comment out lines?
Date: 2003-04-18 09:18:15
Message-ID: 3E9FC2D7.5020906@zhengmai.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


see the little test below:
--------------------8<--------------------------------------
drop function test();
create or replace function test() returns integer as '
begin
-- raise NOTICE ''can't comment out!'';
raise notice ''didn''''t comment out'';
return 1;
end;' language 'plpgsql';

laser_uni=# \i test17.sql
psql:test17.sql:1: ERROR: RemoveFunction: function test() does not exist
psql:test17.sql:4: ERROR: parser: parse error at or near "t" at
character 84
psql:test17.sql:5: ERROR: parser: parse error at or near "raise" at
character 1
psql:test17.sql:6: ERROR: parser: parse error at or near "return" at
character 1
psql:test17.sql:7: WARNING: COMMIT: no transaction in progress
COMMIT
psql:test17.sql:7: ERROR: parser: parse error at or near "' language '"
at character 1
-----------------8<------------------------------------------------------
while change it to:

------------------------8<---------------------------------------------
drop function test();
create or replace function test() returns integer as '
begin
-- raise NOTICE ''cant comment out!'';
raise notice ''didn''''t comment out'';
return 1;
end;' language 'plpgsql';
------------------------8<---------------------------------------------
would be OK, so, the parser still parse those commented lines?

regards

Laser

Browse pgsql-bugs by date

  From Date Subject
Next Message Timothy.Oliver 2003-04-18 17:22:27 postgres sql 7.1.1
Previous Message pgsql-bugs 2003-04-18 06:55:32 Bug #949: Incorrecr parse charset.conf and recode tables.