Thread: 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:

>
> 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
>
>