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;
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
