From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "Greg Donald" <destiney(at)gmail(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: division by zero issue |
Date: | 2004-09-15 18:42:24 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE475CAA@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Thanks, you guys are so helpful.
>
> This works great on my workstation with 7.4.5. But what's
> the 7.2 way of doing it? Our production server is a bit older.
>
> I also tried Mr Fraser's suggestion:
>
> SELECT
> tasks.task_id,
> CASE
> WHEN task_count = '0'
> THEN '0'::int4
> ELSE (task_duration * task_duration_type / task_count) as
> hours_allocated
> END
> FROM
> (
> SELECT
> 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
> ) as intermediate;
>
> but it's producing an error near the AS for some reason I can't tell.
> I tried wrapping it with some parentheses but it didn't help.
You're missing an END:
> SELECT
> tasks.task_id,
> CASE
> WHEN task_count = '0'
> THEN '0'::int4
> ELSE (task_duration * task_duration_type / task_count) END as
^^^^^^^
> hours_allocated
> END
> FROM
...
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2004-09-15 18:44:30 | Re: division by zero issue |
Previous Message | Matthew T. O'Connor | 2004-09-15 18:37:13 | Re: Corrupted Data? |