On Tuesday 04 May 2010 1:55:35 pm Andre Lopes wrote: > HI, > > I have a PLPgSQL function that return void but I need to exit the function > if some condition returns true. > > I have tried to do this, but I got an error: > > [code] > IF pVAL_CHAVE_2 > pVAL_CAMPO1 THEN > RAISE NOTICE 'O campo data fim tem de ser maior que o campo > data inicio.'; > RETURN 0; > END IF; > [/code] > > The error is the folowing: > > [quote] > ERROR: RETURN cannot have a parameter in function returning void at or > near "0" at character 1973 > [/quote] > > My question. How can I display the NOTICE and exit the function? > > Best Regards,