Re: No migration path for MONEY

Sorry my mistake on versions.


darcy=3D> SELECT '1.0'::MONEY::FLOAT;
?column?
--------
       1
(1 row)

darcy=3D> SELECT '1.0'::MONEY::TEXT;
?column?
--------
     1.0
(1 row)

darcy=3D> select version();
version=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=20=20
--------------------------------------------------------------------
PostgreSQL 6.5.2 on i386-unknown-freebsd3.2, compiled by gcc 2.7.2.1
(1 row)



On Wednesday 29 January 2003 09:04, Tom Lane wrote:
> 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=3D# SELECT '1.0'::MONEY::TEXT ;
> ERROR:  Cannot cast type 'money' to 'text'
> regression=3D# 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--=20
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com