From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | "sheila timp" <shilet(at)hotmail(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: cast int to float |
Date: | 2002-01-02 20:32:27 |
Message-ID: | web-539593@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Jules Alberts | 2002-01-03 10:38:22 | Re: some questions about PostgreSQL in general |
Previous Message | Josh Berkus | 2002-01-02 18:59:24 | Re: some questions about PostgreSQL in general |