Re: No migration path for MONEY

Darcy Buskermolen <darcy(at)wavefire(dot)com> writes:
> Sorry my mistake on versions.
> darcy=> SELECT '1.0'::MONEY::FLOAT;
> ?column?
> --------
> 1
> (1 row)
> darcy=> select version();
> version
> --------------------------------------------------------------------
> PostgreSQL 6.5.2 on i386-unknown-freebsd3.2, compiled by gcc 2.7.2.1
> (1 row)

I don't have a 6.5 system around to test anymore, but my recollection is
that back then, constructs like 'literal'::foo::bar were collapsed into
'literal'::bar --- so the above doesn't prove 6.5 could actually convert
money into float. What happens if you take a money column and try to
coerce it, ie "SELECT moneycol::float FROM mytable" ?

regards, tom lane