Re: error in compiling the function -- need help !!!

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(at)postgresql(dot)org