SOLVED: Dividing Money

From: Bob Dusek <bobd(at)palaver(dot)net>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: SOLVED: Dividing Money
Date: 1998-12-02 19:18:06
Message-ID: Pine.LNX.3.96.981202141556.17606B-100000@farout.palaver.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Dusek 1998-12-02 19:20:42 Another Solution: Dividing Money
Previous Message Nicholas Humfrey 1998-12-02 17:48:09 Text Databases