Re: Where clause

From: Michael Landin Hostbaek <mich(at)the-lab(dot)org>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Where clause
Date: 2007-06-26 09:44:53
Message-ID: 20070626094453.GH67974@mich2.itxmarket.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

A. Kretschmer (andreas.kretschmer) writes:
> *untested*
>
> select cid, sum(case when click = true then 1 else 0 end), sum(case when
> view = true then 1 else 0 end) from ...
>

Thanks, but I need the DISTINCT contactid - I don't want the same
contactid counted twice.

Mike

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleas Mantzios 2007-06-26 10:31:03 Re: Where clause
Previous Message A. Kretschmer 2007-06-26 09:01:40 Re: Where clause