I did something like
create function test() returns integer as
'
declare
msg varchar;
begin
msg := "test";
RAISE NOTICE "message is " || msg;
end'
language 'plpgsql';
The function compiled without any error, however, when I tried to run it
as select test(); it broke down with an error message " Unterminated " "
Can anyone help me on this?
Thanks!
--
Wei Weng
Network Software Engineer
KenCast Inc.