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.)
-- 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. +