Using EXIT and labels to exit blocks of statements
От | Danny Lo |
---|---|
Тема | Using EXIT and labels to exit blocks of statements |
Дата | |
Msg-id | c824170b1003021339u3d4a459dvca40ec945050a7f3@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Using EXIT and labels to exit blocks of statements
|
Список | pgsql-novice |
Hi, My novice question is – I’d like to use EXIT statement to exit a block of statements. I copied an example from pg 809 of postgresql 8.4 documentation but received
Following error. Just want to know correct way to use label. Thanks very much.
ERROR: label does not exist at or near "ablock"
LINE 15: EXIT ablock; -- causes exit from the BEGIN block
^
DROP FUNCTION IF EXISTS test_exit();
CREATE OR REPLACE FUNCTION test_exit()
RETURNS void AS
$BODY$
DECLARE
x integer :=0;
stocks bigint := 100100;
<<ablock>>
BEGIN
-- some computations
IF stocks > 100000 THEN
EXIT ablock; -- causes exit from the BEGIN block
END IF;
-- computations here will be skipped when stocks > 100000
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
ALTER FUNCTION test_exit() OWNER TO postgres;
В списке pgsql-novice по дате отправления: