Skip site navigation (1) Skip section navigation (2)

Cast question (NULL -> NUMERIC)

From: Henry House <hajhouse(at)houseag(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Cast question (NULL -> NUMERIC)
Date: 2001-07-13 18:53:38
Message-ID: 20010713115338.A12955@houseag.com (view raw or flat)
Thread:
Lists: pgsql-novice
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?

-- 
Henry House
OpenPGP key available from http://romana.hajhouse.org/hajhouse.asc

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2001-07-13 21:11:25
Subject: Re: Cast question (NULL -> NUMERIC)
Previous:From: GHDate: 2001-07-13 18:46:46
Subject: Re: Silly newbie questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group