Possible bug with LABEL and LOOP in 8.0

Started by Patrick Ficheover 21 years ago1 messagesgeneral
Jump to latest
#1Patrick Fiche
patrick.fiche@aqsacom.com

Hi,

It seems to me that a bug was introduced in 8.0 version.
(I was previously using 7.2.3 so I don't really know in which version the
comportment changed...).
I'm using Beta2 version on WIN32 platform.

----------------------------------------------------------------------------
--------
CREATE OR REPLACE FUNCTION TEST( ) RETURNS int4 AS '

BEGIN

<<LOOP1>>
LOOP
Raise Notice ''Loop 1'';

EXIT LOOP1;
END LOOP;

RETURN 0;

END'
LANGUAGE 'plpgsql';
----------------------------------------------------------------------------
--------

When I call SELECT TEST(), I get the error message :
ERROR: control reached end of function without RETURN
CONTEXT: PL/pgSQL function "test"

If I just change EXIT LOOP1 to EXIT -> everything is OK
I think we previously had the possibility to indicate the LABEL in EXIT
statement...

Regards,

Patrick

---------------------------------------------------------------------------
----------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
----------------------------------------------------------------------------
---------------

Protected by Polesoft Lockspam
http://www.polesoft.com/refer.html