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

#1

Quote:

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

#2

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:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.postgresql.novice comp.databases.postgresql.novice

error in compiling the function -- need help !!! - 08-02-2004 , 12:33 AM

Re: error in compiling the function -- need help !!! - 08-02-2004 , 10:31 PM