sry, one more question ...
I want to trap an exception and return a -1 no matter WHAT it is ... what do
i need to replace <anything> with?
>>>>>>
create or replace function clrsplit(int4) returns unknown as
$$
BEGIN
delete from split where tkid=$1;
EXCEPTION
WHEN <anything>
return -1;
update tk set dtchksp=null where nid=$1;
return 0;
END
$$ language plpgsql;