Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id C6B98475C12 for ; Thu, 25 Jul 2002 14:06:22 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id D306DD610; Thu, 25 Jul 2002 11:06:22 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id C8AD35C03; Thu, 25 Jul 2002 11:06:22 -0700 (PDT) Date: Thu, 25 Jul 2002 11:06:22 -0700 (PDT) From: Stephan Szabo To: "Yudie@axiontech.com" Cc: Subject: Re: problem with plpgsql trigger function: parse error near "" In-Reply-To: <00bc01c233ff$8d5489c0$8a01a8c0@yudie> Message-ID: <20020725110411.O50051-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200207/408 X-Sequence-Number: 8786 On Thu, 25 Jul 2002, Yudie@axiontech.com wrote: > I just tried the trigger function from: > http://developer.postgresql.org/docs/postgres/plpgsql-trigger.html > (You can read the sql command on the bottom of this message.) > > When inserting into emp table i got error: --> parse error near "" > > I just wondering if any of you have the same probelem; What version are you running? The below cut and paste into my 7.3 devel server and a 7.2 server seems to work.