Postgresql: Converting money type to numeric!

Posted by rich on Feb 14, 2008 in coding, Postgresql | 0 comments Quick post here, as I was having trouble finding any information(that worked, or indepth enough to work for what I needed). The type money is now deprecated from postgresql, and a few of our tables contained this data type. This is fine, and worked as we wanted, until there came a time I needed to do a query such as: select * from mytable where (mytable.charge > 0); seems easy enough, but if...
read more