Received: from nezu.gs.verio.net (nezu.gs.verio.net [204.27.65.34]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f63E8Za85027 for ; Tue, 3 Jul 2001 10:08:35 -0400 (EDT) (envelope-from jeckermann@verio.net) Received: by NEZU with Internet Mail Service (5.5.2650.21) id ; Tue, 3 Jul 2001 09:08:24 -0500 Message-ID: <08CD1781F85AD4118E0800A0C9B8580B094B0C@NEZU> From: Jeff Eckermann To: Wei Weng Cc: pgsql-sql@postgresql.org Subject: RE: How do I print a message in a function? Date: Tue, 3 Jul 2001 09:08:20 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain X-Archive-Number: 200107/18 X-Sequence-Number: 3799 I think you need two other things as well: 1. A return statement: "RETURN some-integer;" before the END 2. A semicolon after the END; <-- > -----Original Message----- > From: Jie Liang [SMTP:jliang@ipinc.com] > Sent: Monday, July 02, 2001 7:59 PM > To: Wei Weng > Cc: pgsql-sql@postgresql.org > Subject: Re: How do I print a message in a function? > > You have to use two single quota > > Jie LIANG > > St. Bernard Software > > 10350 Science Center Drive > Suite 100, San Diego, CA 92121 > Office:(858)320-4873 > > jliang@ipinc.com > www.stbernard.com > www.ipinc.com > > On 2 Jul 2001, Wei Weng wrote: > > > I did something like > > > > try this > > > > 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 majordomo@postgresql.org > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html