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