Received: from osage.gate.net (root@osage.gate.net [198.206.134.25]) by hub.org (8.9.1/8.9.1) with ESMTP id NAA03877 for ; Fri, 8 Jan 1999 13:59:29 -0500 (EST) (envelope-from bill@hammondgroves.com) Received: from Bill..hutto.com (tsver1-97.gate.net [199.227.29.97]) by osage.gate.net (8.8.6/8.6.12) with SMTP id NAA47896; Fri, 8 Jan 1999 13:59:09 -0500 Message-Id: <199901081859.NAA47896@osage.gate.net> From: "Bill Hutto" Organization: Hammond Groves To: "Thomas G. Lockhart" Date: Fri, 8 Jan 1999 13:58:10 +0000 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: Money type mapping to backend Reply-to: bill@hammondgroves.com CC: "pgsql-interfaces@hub.org" , Byron Nikolaidis , "Ken J. Wright" Priority: normal In-reply-to: <36963179.A6E79098@alumni.caltech.edu> > > Hey, guess what, I was testing the whole time under Postgres 6.3 and > > it does not require the quotes around money type! > > Only postgres 6.4 requires the quotes! > > That seems kind of weird. Anyone got any comments? > > otoh, with the NUMERIC() and DECIMAL() types implemented by Jan, the > money type is completely and absolutely obsolete in the next release > afaik. Once we get these new types working on all platforms (I've got > troubles on my linux box; anyone else have success on non-BSD machines?) > we can think about a migration/compatibility strategy... I figure if the Numeric and Decimal types are coming pretty soon, I'm probably going to wait and see how they work. If it works according to my docs, the Numeric will map straight to the Jet's Currency type (scaled integer), and hopefully there won't be any quote problems. That would be perfect. Thanks for your help guys, nice job, and I look forward to this upgrade. Cheers, Bill