| From: | Thomas Good <tomg(at)sqlclinic(dot)net> |
|---|---|
| To: | Postgres SQL List <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Casting Money To Numeric |
| Date: | 2002-11-26 19:19:40 |
| Message-ID: | Pine.LNX.4.33.0211261415350.16043-100000@q8.nrnet.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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: tomg(at)sqlclinic(dot)net
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! --
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2002-11-26 23:52:26 | Re: copy from command - quotes and header lines |
| Previous Message | Martin Crundall | 2002-11-26 18:59:55 | Re: celko nested set functions -- tree move |