From: mike g <mike@thegodshalls.com>
To: Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
Cc: pgsql-novice@postgresql.org
Subject: Re: error in compiling the function -- need help !!!
Date: Mon, 02 Aug 2004 22:31:41 -0500
Message-ID: <1091503900.16772.6.camel@localhost.localdomain> (raw)
In-Reply-To: <77ED2BF75D59D1439F90412CC5B109740FA2CEBA@ie10-sahara.hiso.honeywell.com>
References: <77ED2BF75D59D1439F90412CC5B109740FA2CEBA@ie10-sahara.hiso.honeywell.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@thegodshalls.com, Pradeepkumar.Pyatalo@honeywell.com, pgsql-novice@postgresql.org
Subject: Re: error in compiling the function -- need help !!!
In-Reply-To: <1091503900.16772.6.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox