Thread: EXIT <

EXIT <

From
"Patrick Fiche"
Date:
Hi,

It seems to me that a bug was introduced in 8.0 version.
I'm using Beta3 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

Regards,

Patrick
----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------







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