[SQL] How do I print a message in a function?

[Wei Weng]

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.



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]