Re: [SQL] Casting Money To Numeric

2002-11-27 Thread D'Arcy J.M. Cain
On November 26, 2002 02:19 pm, Thomas Good wrote: > Having perused all the online docs I can find it appears there is no > SQL solution for casting the dread money type to numeric. > Is this true? > > select rent::numeric(9,2) from x; > ERROR: Cannot cast type 'money' to 'numeric' Fraid so. That'

[SQL] Casting Money To Numeric

2002-11-26 Thread Thomas Good
Hi All. Having perused all the online docs I can find it appears there is no SQL solution for casting the dread money type to numeric. Is this true? select rent::numeric(9,2) from x; ERROR: Cannot cast type 'money' to 'numeric' I guess my cash ain't nothing but trash... ;-) TIA! --