Fw: Problem Related to Goto

Started by Dinesh Parikhover 24 years ago1 messagesgeneral
Jump to latest
#1Dinesh Parikh
dineshp@newgen.co.in

Dear All
I have a strange problem. Some documents suggests that I can use Goto statement. My program is like this one.

Drop function Gototest();
Create Function Gototest() Returns int4 as'
Declare
DBFirst int2;
Begin
DBFirst := 1;
Start: DBFirst:= DBFirst+1;
If (DBFirst != 10) Then
Goto Start;
End If;
Raise Notice ''val %'',DBFirst;
Return DBFirst;
End;
' language 'plpgsql';

Select Gototest();

But when I am running it , it gives error

DROP
CREATE
ERROR: parser: parse error at or near "start"

What may be cause of it. Actually I am converting oracle stored procedure to postgres function.So what is alternate.Is there any support of Continue statement.

Thanks

Regards
Dinesh Parikh