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! ----------------------------------------------------------------------- Thomas Good e-mail: [EMAIL PROTECTED] Programmer/Analyst phone: (+1) 718.818.5528 Residential Services fax: (+1) 718.818.5056 Behavioral Health Services, SVCMC-NY mobile: (+1) 917.282.7359 -- Geistiges Eigentum ist Diebstahl! -- ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html