Postgres Pro
Downloads
Home   >   mailing lists

Is there a GoTo ? - Mailing list pgsql-general

From İlyas Derse
Subject Is there a GoTo ?
Date
Msg-id CALcdmyRoL87r4H074joV4ryA3tYO+dbKr6AEocwAt9wOe52iDQ@mail.gmail.com
Whole thread Raw
Responses Re: Is there a GoTo ?
Re: Is there a GoTo ?
Re: Is there a GoTo ?
List pgsql-general
Tree view
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 $$
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: "Werner Kuhnle"
Date:
Subject: Re-2: Problem with SqlState=23505 when inserting rows
Next
From: Pavel Stehule
Date:
Subject: Re: Is there a GoTo ?