Received: from sss.pgh.pa.us (sss.pgh.pa.us [216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4A0DNA85254 for ; Wed, 9 May 2001 20:13:23 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f4A0CpR13004; Wed, 9 May 2001 20:12:51 -0400 (EDT) To: Joseph Shraibman cc: Joe Conway , pgsql-sql@postgresql.org Subject: Re: 'record old is unassigned yet' when using trigger in 7.1.1 In-reply-to: <3AF9D542.88C9FACD@selectacast.net> References: <3AF9AECE.DE93E098@selectacast.net> <000c01c0d8d2$cefddf90$54d410ac@jecw2k1> <3AF9D542.88C9FACD@selectacast.net> Comments: In-reply-to Joseph Shraibman message dated "Wed, 09 May 2001 19:39:46 -0400" Date: Wed, 09 May 2001 20:12:51 -0400 Message-ID: <12999.989453571@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200105/73 X-Sequence-Number: 2874 I think you're short an END IF. Last I checked, plpgsql didn't have an "else if" construct, so it wants an END IF to go with each IF. regards, tom lane