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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Krzysztof Walkiewicz
Дата:
Сообщение: Re: How to build a query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Using EXIT and labels to exit blocks of statements