Re: [INTERFACES] Problems with money fields.

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;

  Hello,
  I was wondering if someone could shed some light on money fileds for me.  I  am having a problem in that a money
fieldplus 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;  total  -----  $0.00
  (2 rows)
  select '1'::money + total from test;  ?column?  --------  $1.00   
  (2 rows)
  Why is the second column blank?  This is really throwing my calculations  because there are times when $0.00 is
differentfrom no value at all.  Also, how can I get a query of all rows where the money value is NULL?  This fails:
 
  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 = '';    total  -----  $0.00  (1 row)
  If I can't query for a money field with a NULL value, why can I insert one?
  Thank you,  Matthew Hagerty