Re: No migration path for MONEY

Darcy Buskermolen <darcy(at)wavefire(dot)com> writes:
> In 7.1 and prior I could do a SELECT '1.0'::MONEY::TEXT or to NUMERIC
> or to FLOAT even.

No, you couldn't.

regression=# SELECT '1.0'::MONEY::TEXT ;
ERROR: Cannot cast type 'money' to 'text'
regression=# select version();
version
------------------------------------------------------------------
PostgreSQL 7.1.3 on hppa2.0-hp-hpux10.20, compiled by GCC 2.95.3
(1 row)

7.0 is the same. 7.2 is the same. 7.3 is the same except it doesn't
put quotes in the error message ;-)

It might be worth adding some conversion functions in the future ---
but don't assert that we've removed such, because we have not.

regards, tom lane