From: | davidgn(at)servidor(dot)unam(dot)mx |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | does parser still parse those comment out lines? |
Date: | 2003-04-19 17:31:43 |
Message-ID: | 1050773503.3ea187ff45d30@www.correo.unam.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
-------------------------------------------------
Obtén tu correo en www.correo.unam.mx
UNAMonos Comunicándonos
From | Date | Subject | |
---|---|---|---|
Next Message | elein | 2003-04-19 17:59:46 | Re: mariposa |
Previous Message | Bruno Wolff III | 2003-04-19 16:11:21 | stddev returns 0 when there is one row |