Re: how to check SQLSTATE

Hi again, thanks for your guidance, this is the error I got trying to save
my fuction:
ERROR: unrecognized exception condition "no_data"
CONTEXT: compile of PL/pgSQL function "fn_verificar_aportes_socio" near
line 36

the symbol is correct , i checked it in the appendix A postgres error codes
and constants, have you got any idea what the problem could be.
....
loop
Begin
fetch bla.....
Exception
when no_data then
exit;
end;
....
end loop;
......
this is on suse 10, postgres 8.1.4

thanks in advance

Hugo