Re: Is there a GoTo ?

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

čt 16. 1. 2020 v 11:53 odesílatel İlyas Derse <ilyasderse@xxxxxxxxx> napsal:

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

 

CREATE OR REPLACE FUNCTION test(i integer) RETURNS integer AS $$
BEGIN
IF i<0 THEN 
RETURN i + 1;
ELSE
  GOTO label1;
END IF
<<label1>>
RETURN null;
END;
$$ LANGUAGE plpgsql;