Postgres Pro
Downloads
Home   >   mailing lists

Re: Where clause - Mailing list pgsql-sql

From Michael Landin Hostbaek
Subject Re: Where clause
Date
Msg-id 20070626094453.GH67974@mich2.itxmarket.com
Whole thread Raw
In response to Re: Where clause  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: Where clause  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: Where clause  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Where clause
Next
From: Achilleas Mantzios
Date:
Subject: Re: Where clause