Re: how to check SQLSTATE

[Hugo <htakada@xxxxxxxxx>]

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