[GENERAL] Possible bug with LABEL and LOOP in 8.0

[Patrick Fiche]

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 : [EMAIL PROTECTED]
-------------------------------------------------------------------------------------------

 

Protected by Polesoft Lockspam

http://www.polesoft.com/refer.html