Skip site navigation (1) Skip section navigation (2)

Using EXIT and labels to exit blocks of statements

From: Danny Lo <lo(dot)dannyk(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Using EXIT and labels to exit blocks of statements
Date: 2010-03-02 21:39:42
Message-ID: c824170b1003021339u3d4a459dvca40ec945050a7f3@mail.gmail.com (view raw or flat)
Thread:
Lists: 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;
>
>
>
>

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-03-03 00:58:29
Subject: Re: Using EXIT and labels to exit blocks of statements
Previous:From: Krzysztof WalkiewiczDate: 2010-03-02 11:13:03
Subject: Re: How to build a query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group