How do I print a message in a function? - Mailing list pgsql-sql

From Wei Weng
Subject How do I print a message in a function?
Date
Msg-id 994117573.6587.5.camel@Monet
Whole thread Raw
Responses Re: How do I print a message in a function?  (Jie Liang <jliang@ipinc.com>)
List pgsql-sql
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.




pgsql-sql by date:

Previous
From: Wei Weng
Date:
Subject: Null set
Next
From: Jie Liang
Date:
Subject: Re: How do I print a message in a function?