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/
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 |