Re: casting money type to float

found an email from you, from Tue, 12 May 1998, where you describe the
problems I am having with regards to casting from money to other
types.
"So there is some funny interaction on the casting, the same as you
found in v6.3.2 (and presumably forever), which I will look into..."

But these problems still exist in 6.4BETA2... Is this something that
will be fixed?

To summarize the problem in case it isn't fresh in your mind: casting
a money column in a table to float8 results in gibberish. Casting a
constant seems to work fine. Casts to other types than float8 seem
equally broken in the table case.

How are you doing the casting? I'm having trouble figuring out what
syntax you are using to get gibberish...

- Tom

postgres=> create table mm (m money);
CREATE
postgres=> insert into mm values ('1');
INSERT 18473 1
postgres=> insert into mm values ('2.50');
INSERT 18474 1
postgres=> select * from mm;
m
-----
$1.00
$2.50
(2 rows)

postgres=> select float8(m) from mm;
ERROR: No such function 'float8' with the specified attributes
postgres=> select m * 1.0 from mm;
?column?
--------
$1.00
$2.50
(2 rows)

postgres=> select m::float8 from mm;
ERROR: No such function 'float8' with the specified attributes