division by zero issue

From: Greg Donald <destiney(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: division by zero issue
Date: 2004-09-15 16:30:51
Message-ID: ea9da26c0409150930176a5a55@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Katsaros Kwn/nos 2004-09-15 16:34:06 Problems with SPI memory management
Previous Message Steve Atkins 2004-09-15 16:29:13 Converting varchar() to text