Hi

čt 16. 1. 2020 v 11:53 odesílatel İlyas Derse <ilyasde...@gmail.com> 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 $$BEGINIF i<0 
> THEN RETURN i + 1;ELSE
>   GOTO label1;END IF<<label1>>RETURN null;END;$$ LANGUAGE plpgsql;
>
>

Reply via email to