Bruce Momjian wrote:
> D'Arcy J.M. Cain wrote:
> > On Sat, 24 Nov 2007 11:27:38 -0500 (EST)
> > Bruce Momjian <bruce@momjian.us> wrote:
> > > I am confused about two other items with MONEY. First, why can't
> > > anything but a string be cast to this type?
> > >
> > > test=> select 871234872319489323::money;
> > > ERROR: cannot cast type bigint to money
> > > LINE 1: select 871234872319489323::money;
> > > ^
> > > test=> select 871234872::money;
> > > ERROR: cannot cast type integer to money
> > > LINE 1: select 871234872::money;
> > > ^
> > > test=> select 87123487231.3::money;
> > > ERROR: cannot cast type numeric to money
> > > LINE 1: select 87123487231.3::money;
> > > ^
> >
> > I agree. I wasn't the one that added the meta information.
>
> OK, so the big question then is if we are un-depricating this data type,
> does it have the behavior we want? (And the regression addition will be
> helpful too.)
Added to TODO list:
* Allow MONEY to be cast to/from other numeric data types
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +