From: Matthew Hagerty <matthew@venux.net>
To: pgsql-interfaces@postgreSQL.org
Subject: Problems with money fields.
Date: Tue, 18 May 1999 20:39:41 -0400
Message-ID: <4.1.19990518203016.00ae1d00@mail.venux.net> (raw)
Hello,
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;
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 different from 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: matthew@venux.net
Subject: Re: Problems with money fields.
In-Reply-To: <4.1.19990518203016.00ae1d00@mail.venux.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox