cast int to float

From: "sheila timp" <shilet(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: cast int to float
Date: 2001-12-29 23:19:27
Message-ID: F268gEHCqHkl9UP1X010000eae4@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'm creating a new database-item by dividing two existing items. When these
items are initially declared as float, there is no problem. On the other
hand, when they are declared as int initially and later converted to float,
I get the error: float8div: divide by zero error. Maybe I didn't do the
casting right. This is what I did:

((cast(item1 as float))/(cast(item2 as float) + cast (item3 as float))) as
item4.

I played around with putting the brackets at different places, but every
time got the same error message.
Hopefully someone can advise me what to do,

Thanks Sheila

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Francisco Reyes 2001-12-31 17:03:01 Re: appropriate sort_mem & shared buffers
Previous Message sheila timp 2001-12-29 22:26:12 cast int to float