division by zero error in a request

Поиск
Список
Период
Сортировка
От Bernard Grosperrin
Тема division by zero error in a request
Дата
Msg-id wf3mczdcqge1.1vyz19vu3vvi9.dlg@40tude.net
обсуждение исходный текст
Ответы Re: division by zero error in a request  (Oisin Glynn <me@oisinglynn.com>)
Список pgsql-general
I wants to make a view giving me some statistics.

I am not sure to understand why something like this

SELECT location_id, (sold_parts_amount_dly + sold_labor_amount_dly) /
(sold_parts_amount_dly + sold_labor_amount_dly) from sales

give me a division by zero error?

If that is not the way to go, should I write a function that I would call
instead?

Thanks,
Bernard

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

Предыдущее
От: "binberati"
Дата:
Сообщение: FastCgi / PostgreSQL: FATAL: Ident authentication failed for user "user_name"
Следующее
От: Daniel.Chmielewski@gmail.com
Дата:
Сообщение: trigger postgresql 7.4