D'Arcy J.M. Cain wrote: > On Sat, 24 Nov 2007 11:27:38 -0500 (EST) > Bruce Momjian <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
