"James M Doherty" <jim(at)jdoherty(dot)net> writes:
> The above function is called as follows:
> trec.tot_value :=
> The result is always null.
It's impossible to do much with this when you have not shown us a
complete test case, but I'm wondering if your calling function is
passing parameter values that don't match anything in the
bank_balance_sheet table. That would cause the sum() to return
null and then total_due would go to null as well.
It's pretty bogus that SQL defines sum() over no rows to return
null rather than zero, but the spec is perfectly clear about it.
You might want to change sum(bbs.bbs_current_balance) to
coalesce(sum(bbs.bbs_current_balance), 0) if you need to deal with
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2006-04-13 16:55:41|
|Subject: Re: BUG #2391: "Similar to" pattern matching does not operate as documented |
|Previous:||From: Tom Lane||Date: 2006-04-13 16:43:16|
|Subject: Re: BUG #2390: check constraint |