Postgres Pro
Downloads
Home   >   mailing lists

Casting Money To Numeric - Mailing list pgsql-sql

From Thomas Good
Subject Casting Money To Numeric
Date
Msg-id Pine.LNX.4.33.0211261415350.16043-100000@q8.nrnet.org
Whole thread Raw
Responses Re: Casting Money To Numeric  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-sql
Tree view 
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@sqlclinic.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!              --

pgsql-sql by date:

Previous
From: "Martin Crundall"
Date:
Subject: Re: celko nested set functions -- tree move
Next
From: Peter Eisentraut
Date:
Subject: Re: copy from command - quotes and header lines