Hugo <[EMAIL PROTECTED]> writes:
> 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
NO_DATA isn't an error condition, on
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 co
sorry, forgot to mention psql8.1.4 on fedora core 4On 10/6/06, A. Kretschmer <[EMAIL PROTECTED]
> wrote:am Thu, dem 05.10.2006, um 17:45:36 -0300 mailte Hugo folgendes:> Hi,
>> is it possible to check for sqlstate inside a function , something like:>>loop> fetch bla.> i
am Thu, dem 05.10.2006, um 17:45:36 -0300 mailte Hugo folgendes:
> Hi,
>
> is it possible to check for sqlstate inside a function , something like:
>
>loop
> fetch bla.
> if sqlstate = '02000' then
> exit;
> end if;
>
>end loop;
> if I
