In this function I have to GOTO to a label1, but GOTO keyword is not working, can you please help me in getting the way from which I am able to jump from a particular code to label.
Thanks...
no, plpgsql has not GOTO statement. It cannot be implemented in interpret type used by plpgsql.
Regards
Pavel
CREATEOR REPLACE FUNCTION test(i integer) RETURNS integer AS$$BEGINIF i<0THENRETURN i +1;ELSEGOTO label1;ENDIF<<label1>>RETURNnull;END;$$ LANGUAGE plpgsql;