Hi guys,
I trying to return a 0.00 from a function it there are no records found else
return the amount.
create or replace function danmeans_getpayments(text)
returns numeric as
$BODY$
declare invoice_num ALIAS FOR $1; _paidamt numeric;
BEGIN select sum(aropen_paid) into _paidamt FROM public.aropen where
aropen_applyto is not null and (aropen_applyto = $1) ;
IF (FOUND) THEN RETURN _paidamt ;END IF; RETURN 0.00 ;
END;
$BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100
But all I get is either a blank or the amount paid. What am I doing wrong???
Johnf