Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 03017475992
	for <pgsql-sql@postgresql.org>; Tue,  6 Aug 2002 18:15:48 -0400 (EDT)
Received: from amadeus.quorum.com (dmz.qlanier.com [208.245.17.74])
	by postgresql.org (Postfix) with SMTP id 33F9E47597A
	for <pgsql-sql@postgresql.org>; Tue,  6 Aug 2002 18:15:47 -0400 (EDT)
Received: by amadeus.quorum.com(Lotus SMTP MTA v4.6.7 (934.1 12-30-1999)) id
	86256C0D.007A46A2 ; Tue, 6 Aug 2002 17:15:34 -0500
X-Lotus-FromDomain: QLS
From: rramostalo@quorum.com
To: pgsql-sql@postgresql.org
Message-ID: <86256C0D.007A463B.00@amadeus.quorum.com>
Date: Wed, 7 Aug 2002 06:12:46 +0800
Subject: control reaches end of trigger procedure without RETURN
Mime-Version: 1.0
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/128
X-Sequence-Number: 8974



create function duplicate_images() returns OPAQUE as'
     DECLARE
          myrec RECORD;
     BEGIN
          if TG_OP = ''INSERT'' then
               select * into myrec from images where page=NEW.page and
path=NEW.path;
               if found then
                    raise exception ''insert failed: duplicate record found'';
               end if;
          end if;
     end;
' language 'plpgsql';