Re: Is there a GoTo ? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Is there a GoTo ?
Date
Msg-id CAFj8pRDi0bx3wYnmwCaFosKBLfGisSxF5oAfP1y-Vg-ppHyTJQ@mail.gmail.com
Whole thread Raw
In response to Is there a GoTo ?  (İlyas Derse <ilyasderse@gmail.com>)
List pgsql-general
Hi

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

pgsql-general by date:

Previous
From: İlyas Derse
Date:
Subject: Is there a GoTo ?
Next
From: "Arnaud L."
Date:
Subject: minimal wal_level on subscriber