Re: Confused with LABEL and LOOP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Patrick Fiche" <patrick(dot)fiche(at)aqsacom(dot)com>
Cc: "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org>, Jan Wieck <JanWieck(at)Yahoo(dot)com>
Subject: Re: Confused with LABEL and LOOP
Date: 2004-10-12 15:37:45
Message-ID: 3463.1097595465@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> "Patrick Fiche" <patrick(dot)fiche(at)aqsacom(dot)com> writes:
>> I'm a bit confused with the use of Label for loops in PostgreSQL.

> Sure looks like a bug to me.

Ah-hah: it's a case-sensitivity problem. The <<>> construct downcases
its label identifier, but EXIT forgets to do so. Spell it as
"EXIT loop1" and you'll be OK.

I'll fix this for 8.0.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-12 15:48:55 Re: Rule uses wrong value
Previous Message Jerry LeVan 2004-10-12 15:34:59 Re: Message-ID as unique key?