SOLVED: Dividing Money
Well,
I've still not come up with a way of directly dividing money types, but
here's what I came up with:
select price, price * (1::float / 2::float) as halfofprice from
item_money;
It seems kind of kludgey, but.... my mind can do no better, at this point.
Thanks for all the help on this one.
'til next time,
Bob
Yea, that's like the markup function I sent you.. :)
No one has said, by the way, WHY you can't devide money..
On Wed, 2 Dec 1998, Bob Dusek wrote:
Show quoted text
Well,
I've still not come up with a way of directly dividing money types, but
here's what I came up with:select price, price * (1::float / 2::float) as halfofprice from
item_money;It seems kind of kludgey, but.... my mind can do no better, at this point.
Thanks for all the help on this one.
'til next time,
Bob