Darcy Buskermolen <darcy@wavefire.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
