SOLVED: Dividing Money - Mailing list pgsql-general

From Bob Dusek
Subject SOLVED: Dividing Money
Date
Msg-id Pine.LNX.3.96.981202141556.17606B-100000@farout.palaver.net
Whole thread Raw
Responses Re: [GENERAL] SOLVED: Dividing Money
List pgsql-general
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


pgsql-general by date:

Previous
From: Nicholas Humfrey
Date:
Subject: Text Databases
Next
From: Bob Dusek
Date:
Subject: Another Solution: Dividing Money