Received: from smtp013.mail.yahoo.com (smtp013.mail.yahoo.com [216.136.173.57]) by postgresql.org (Postfix) with SMTP id DC9D6475D53 for ; Thu, 25 Jul 2002 14:06:32 -0400 (EDT) Received: from psc.progress.com (HELO Yahoo.com) (janwieck@192.233.92.200 with plain) by smtp.mail.vip.sc5.yahoo.com with SMTP; 25 Jul 2002 18:06:32 -0000 Message-ID: <3D403E1E.B9430D68@Yahoo.com> Date: Thu, 25 Jul 2002 14:06:22 -0400 From: Jan Wieck X-Mailer: Mozilla 4.79 [en] (X11; U; Linux 2.2.14-6.1.1smp i686) X-Accept-Language: en MIME-Version: 1.0 To: "Yudie@axiontech.com" Cc: pgsql-sql@postgresql.org Subject: Re: problem with plpgsql trigger function: parse error near "" References: <00bc01c233ff$8d5489c0$8a01a8c0@yudie> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200207/409 X-Sequence-Number: 8787 "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.) There have been issues with carriage-returns in PL/pgSQL. If you cut'n'pasted that from the HTML into some file or directly into a psql prompt, you likely got bitten by that. Try to put the content into a file and make sure that is only has linefeeds. vi :set notextmode :wr filename :q psql dbname