X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D9F9B8BA0D1 for ; Fri, 11 Feb 2005 19:49:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23247-01 for ; Fri, 11 Feb 2005 19:49:18 +0000 (GMT) Received: from priv-edtnes46.telusplanet.net (defout.telus.net [199.185.220.240]) by svr1.postgresql.org (Postfix) with ESMTP id D6AA08BA0D0 for ; Fri, 11 Feb 2005 19:49:18 +0000 (GMT) Received: from ignacio ([205.206.124.119]) by priv-edtnes46.telusplanet.net (InterMail vM.6.01.04.00 201-2131-118-20041027) with ESMTP id <20050211194917.VJHS289.priv-edtnes46.telusplanet.net@ignacio>; Fri, 11 Feb 2005 12:49:17 -0700 From: "Ignacio Colmenero" To: "'Tom Lane'" Cc: Subject: Re: ERROR: control reached end of function without RETURN Date: Fri, 11 Feb 2005 12:49:13 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcUQcXiQVbDy248vQI6rws5mTmDBYwAAUgsg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: <12914.1108150093@sss.pgh.pa.us> Message-Id: <20050211194917.VJHS289.priv-edtnes46.telusplanet.net@ignacio> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/667 X-Sequence-Number: 73471 Thanks Tom. I didn't know I needed a RETURN statement at the end. I assumed that the "return next" statement would be enough. It works fine now. ----------------------------------------------- Ignacio Colmenero Software Development Micotan Software Company Ltd. -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane Sent: February 11, 2005 12:28 PM To: Ignacio Colmenero Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] ERROR: control reached end of function without RETURN "Ignacio Colmenero" writes: > I get the error: ERROR: control reached end of function without RETURN > What can be wrong? You don't have a RETURN statement. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq