Is there a GoTo ?

From: İlyas Derse <ilyasderse(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Is there a GoTo ?
Date: 2020-01-16 10:48:41
Message-ID: CALcdmyRoL87r4H074joV4ryA3tYO+dbKr6AEocwAt9wOe52iDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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...

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;

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2020-01-16 10:59:11 Re: Is there a GoTo ?
Previous Message Werner Kuhnle 2020-01-16 08:14:57 Re-2: Problem with SqlState=23505 when inserting rows