Re: cast int to float

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: cast int to float
Дата
Msg-id web-539593@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на cast int to float  ("sheila timp" <shilet@hotmail.com>)
Список 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@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: some questions about PostgreSQL in general
Следующее
От: "Jules Alberts"
Дата:
Сообщение: Re: some questions about PostgreSQL in general