division by zero issue

Поиск
Список
Период
Сортировка
От Greg Donald
Тема division by zero issue
Дата
Msg-id ea9da26c0409150930176a5a55@mail.gmail.com
обсуждение исходный текст
Ответы Re: division by zero issue  (Jean-Luc Lachance <jllachan@sympatico.ca>)
Re: division by zero issue  (Guy Fraser <guy@incentre.net>)
Re: division by zero issue  (Chester Kustarz <chester@arbor.net>)
Список pgsql-general
Converting some MySQL code to work with Postgres here.

I have this query:

SELECT
  tasks.task_id,
  (tasks.task_duration * tasks.task_duration_type /
count(user_tasks.task_id)) as hours_allocated
FROM tasks
LEFT JOIN user_tasks
  ON tasks.task_id = user_tasks.task_id
WHERE tasks.task_milestone = '0'
GROUP BY
  tasks.task_id,
  task_duration,
  task_duration_type
;

The problem is that sometimes count(user_tasks.task_id) equals zero,
so I get the division by zero error.  Is there a simple way to make
that part of the query fail silently and just equal zero instead of
dividing and producing the error?

TIA..

--
Greg Donald
http://gdconsultants.com/
http://destiney.com/

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

Предыдущее
От: Steve Atkins
Дата:
Сообщение: Converting varchar() to text
Следующее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: division by zero issue