On Mon, Sep 9, 2013 at 8:12 AM, Marc Mamin wrote:
> hi,
>
> in addition to the others comments, you can also remove " ELSE 0 " from
> your query.
>
> It will result in values that are discarded by SUM.
>
>
For that matter, you could clean this up by using COUNT as your aggregate
with a
hi,
in addition to the others comments, you can also remove " ELSE 0 " from your
query.
It will result in values that are discarded by SUM.
regards,
Marc Mamin
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of jane...@web.de
Sent: Montag, 9. S
On 09/08/2013 07:12 PM, jane...@web.de wrote:
Hi,
this is my query:
SELECT user,
sum(CASE WHEN lev >= 50 AND lev < 70 THEN 1 ELSE 0 END) as a,
sum(CASE WHEN lev >= 70 AND lev < 80 THEN 1 ELSE 0 END) as b,
sum(CASE WHEN lev >= 80 AND lev <= 90 THEN 1 ELSE 0 END) as c,
On 9 Září 2013, 3:12, jane...@web.de wrote:
> Hi, this is my query: SELECT user, sum(CASE WHEN lev >= 50
> AND lev < 70 THEN 1 ELSE 0 END) as a,
> sum(CASE WHEN lev >= 70 AND lev < 80 THEN 1 ELSE 0 END) as b,
> sum(CASE WHEN lev >= 80 AND lev 90 THEN 1 ELSE 0 END)
does
sum (case when lev >= 50 then 1 else 0 end) as matches
do what you want?
On Sun, Sep 8, 2013 at 9:12 PM, wrote:
> Hi,
>
> this is my query:
> SELECT user,
> sum(CASE WHEN lev >= 50 AND lev < 70 THEN 1 ELSE 0 END) as a,
> sum(CASE WHEN lev >= 70 AND lev < 80 THEN 1 E
