Re: [GENERAL] SOLVED: Dividing Money

From: Gregory Maxwell <greg(at)z(dot)ml(dot)org>
To: Bob Dusek <bobd(at)palaver(dot)net>
Cc: PostgreSQL General <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] SOLVED: Dividing Money
Date: 1998-12-02 20:15:46
Message-ID: Pine.LNX.3.96.981202151513.29275A-100000@z.ml.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dustin Sallings 1998-12-02 23:20:08 Re: [GENERAL] Text Databases
Previous Message Chris Williams 1998-12-02 19:26:37 Need immediate help with install