Hi,Is there a way to check how many records where affected by a delete or update sentence in a trigger function ??thanksHugo
On 10/6/06,
Hugo <[EMAIL PROTECTED]> wrote:
OK, thanks, I'm porting a lot of sybase storedprocedures, and there are lots of "if
sqlstate.." statements that i need to transl
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
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 try to save the above I get a : sqlstate not defined errorThen I tried this with no success: ..