| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | İlyas Derse <ilyasderse(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Is there a GoTo ? |
| Date: | 2020-01-16 10:59:11 |
| Message-ID: | CAFj8pRDi0bx3wYnmwCaFosKBLfGisSxF5oAfP1y-Vg-ppHyTJQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
čt 16. 1. 2020 v 11:53 odesílatel İlyas Derse <ilyasderse(at)gmail(dot)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;
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnaud L. | 2020-01-16 11:09:15 | minimal wal_level on subscriber |
| Previous Message | İlyas Derse | 2020-01-16 10:48:41 | Is there a GoTo ? |