Received: from smtp.snet.net (smtp.snet.net [204.60.6.55]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f62MeKa03313 for ; Mon, 2 Jul 2001 18:40:20 -0400 (EDT) (envelope-from wweng@kencast.com) Received: from pop.snet.net (pop.snet.net [204.60.6.9]) by smtp.snet.net (8.11.1/8.11.1/SNET-mx-1.4/D-1.10/O-1.7) with ESMTP id f62MeHC29609 for ; Mon, 2 Jul 2001 18:40:17 -0400 (EDT) Received: from [192.168.1.83] (167.95.252.64.snet.net [64.252.95.167]) by pop.snet.net (8.11.1/8.11.1/SNET-pop-1.5/D-1.8/O-1.6) with ESMTP id f62MeHr10295 for ; Mon, 2 Jul 2001 18:40:17 -0400 (EDT) Subject: How do I print a message in a function? From: Wei Weng To: pgsql-sql@postgresql.org Content-Type: text/plain X-Mailer: Evolution/0.10 (Preview Release) Date: 02 Jul 2001 19:46:03 -0400 Message-Id: <994117573.6587.5.camel@Monet> Mime-Version: 1.0 X-Archive-Number: 200107/10 X-Sequence-Number: 3791 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.