I have the following query:
SELECT cast( sum(amount) AS NUMERIC(9,2) ) ...
WHERE postdate < $startdate
(where $startdate is replaced with the user's entry at runtime) which returns
the balance forward of the amount column for the user-suplied date correcly
unless the user supplies a $startdate such that no culumns are being added.
In this case NULL is returned. I want to receive 0.00 in this case instead of
NULL, so I added the cast above, but NULL is still returned. Any ideas?
OpenPGP key available from http://romana.hajhouse.org/hajhouse.asc
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2001-07-13 21:11:25|
|Subject: Re: Cast question (NULL -> NUMERIC) |
|Previous:||From: GH||Date: 2001-07-13 18:46:46|
|Subject: Re: Silly newbie questions|