Обсуждение: cast int to float
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
Sheila, > 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: Can you show what values you are using? When I see a "divide by zero" error, my first thought is that you are trying to divide by zero. -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco