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]