Apparently a NULL money value is not equal to zero. That is probably
a good thing.
The select you want for selecting all of the null values is:
SELECT * FROM test WHERE total IS NULL;
I was wondering if someone could shed some light on money fileds for me. I
am having a problem in that a money field plus a null money field equals
null. Try this:
create table test(total money);
insert into test values('');
insert into test valuse(NULL);
select * from test;
select '1'::money + total from test;
Why is the second column blank? This is really throwing my calculations
because there are times when $0.00 is different from no value at all.
Also, how can I get a query of all rows where the money value is NULL?
select * from test where total = NULL;
ERROR: parser: parse error at or near "null"
and this gives me the rows with $0.00:
select * from test where total = '';
If I can't query for a money field with a NULL value, why can I insert one?
In response to
pgsql-interfaces by date
|Next:||From: Hannu Krosing||Date: 1999-05-19 08:33:20|
|Subject: Re: [INTERFACES] Problems with money fields.|
|Previous:||From: Matthew Hagerty||Date: 1999-05-19 00:39:41|
|Subject: Problems with money fields.|