Re: [GENERAL] exception question ....

2007-05-20 Thread Tom Lane
"madhtr" <[EMAIL PROTECTED]> writes: > I want to trap an exception and return a -1 no matter WHAT it is ... what do > i need to replace with? OTHERS regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our l

[GENERAL] exception question ....

2007-05-20 Thread madhtr
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 with? create or replace function clrsplit(int4) returns unknown as $$ BEGIN delete from split where tkid=$1; EXCEPTION WHEN return -1; update tk set dtchksp=null wher