Michael Landin Hostbaek wrote:
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.
... GROUP BY cid
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
