pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feederror in compiling the function -- need help !!!
2+ messages / 2 participants
[nested] [flat]
* error in compiling the function -- need help !!!
@ 2004-08-02 05:33 Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
2004-08-03 03:31 ` Re: error in compiling the function -- need help !!! mike g <mike@thegodshalls.com>
0 siblings, 1 reply; 2+ messages in thread
From: Pradeepkumar, Pyatalo (IE10) @ 2004-08-02 05:33 UTC (permalink / raw)
To: pgsql-novice@postgresql.org
> 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
>
Attachments:
Procedures.sql (application/octet-stream, 1.3K) download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: error in compiling the function -- need help !!!
2004-08-02 05:33 error in compiling the function -- need help !!! Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
@ 2004-08-03 03:31 ` mike g <mike@thegodshalls.com>
0 siblings, 0 replies; 2+ messages in thread
From: mike g @ 2004-08-03 03:31 UTC (permalink / raw)
To: Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>; +Cc: pgsql-novice@postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-08-03 03:31 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-02 05:33 error in compiling the function -- need help !!! Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
2004-08-03 03:31 ` mike g <mike@thegodshalls.com>
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