does parser still parse those comment out lines?

Поиск
Список
Период
Сортировка
От weiping He
Тема does parser still parse those comment out lines?
Дата
Msg-id 3EA0E84A.2020904@zhengmai.com.cn
обсуждение исходный текст
Ответы Re: does parser still parse those comment out lines?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: does parser still parse those comment out lines?  (Ken Williams <ken@mathforum.org>)
Список pgsql-general
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?
Is it a bug?

regards

Laser


В списке pgsql-general по дате отправления:

Предыдущее
От: Network Administrator
Дата:
Сообщение: Re: 7.3 PDF documentation
Следующее
От: Alessandro Bottoni
Дата:
Сообщение: Status of the PGSQL replication projects?