Postgres Pro
Downloads
Home   >   mailing lists

Re: Using EXIT and labels to exit blocks of statements - Mailing list pgsql-novice

From Tom Lane
Subject Re: Using EXIT and labels to exit blocks of statements
Date
Msg-id 27678.1267577909@sss.pgh.pa.us
Whole thread Raw
In response to Using EXIT and labels to exit blocks of statements  (Danny Lo <lo.dannyk@gmail.com>)
List pgsql-novice
Tree view 
Danny Lo <lo.dannyk@gmail.com> writes:
>> Following error. Just want to know correct way to use label. Thanks very
>> much.

You need to put the <<label>> before the DECLARE, not after --- see the
syntax examples here:
http://www.postgresql.org/docs/8.4/static/plpgsql-structure.html

I think it's a bug that it's not throwing an error for the label
placement as you have it.

            regards, tom lane

pgsql-novice by date:

Previous
From: Danny Lo
Date:
Subject: Using EXIT and labels to exit blocks of statements
Next
From: Atif Jung
Date:
Subject: Array or not Array?