Subject: Re: error in compiling the function -- need help !!!
From: mike g <mike@thegodshalls.com>
Reply-To: mike@thegodshalls.com
To: "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com>
Cc: pgsql-novice@postgresql.org
In-Reply-To: 
 <77ED2BF75D59D1439F90412CC5B109740FA2CEBA@ie10-sahara.hiso.honeywell.com>
References: 
 <77ED2BF75D59D1439F90412CC5B109740FA2CEBA@ie10-sahara.hiso.honeywell.com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Message-Id: <1091503900.16772.6.camel@localhost.localdomain>
Mime-Version: 1.0
Date: Mon, 02 Aug 2004 22:31:41 -0500

Hello,

I think you need another return statement near the end. Between the ELSE
and END IF so that if your code hits that point there is a Return called
to end the function.

HTH.

Mike
On Mon, 2004-08-02 at 00:33, Pradeepkumar, Pyatalo (IE10) wrote:
> > Hi ,
> > 
> > I have attached the function that I am trying to run. But I am getting the
> > following error -
> > 
> > select * from pp_readenum('STAT42','PointDefinitionType')  as alias;
> > ERROR: syntax error at or near ";"
> > CONTEXT: compile of PL/pgSQL function "pp_readenum" near line 41 
> > <<Procedures.sql>> 
> > 
> > I have checked the function many times....I could not figure out what
> > could be wrong....any help on this.
> > 
> > 	With Best Regards 
> > 	Pradeep Kumar P J 
> > 
> 
> ______________________________________________________________________
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org