Re: division by zero issue

From: Greg Donald <destiney(at)gmail(dot)com>
To: Jean-Luc Lachance <jllachan(at)sympatico(dot)ca>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: division by zero issue
Date: 2004-09-15 17:23:55
Message-ID: ea9da26c04091510232986335e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 15 Sep 2004 12:55:24 -0400, Jean-Luc Lachance
<jllachan(at)sympatico(dot)ca> wrote:
> Add :
>
> AND count(user_tasks.task_id) > 0 in the where clause.

I get the error:
aggregates not allowed in WHERE clause

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2004-09-15 17:27:26 Re: psql + autocommit
Previous Message Peter Eisentraut 2004-09-15 17:17:51 Re: psql + autocommit