Search Postgresql Archives

count case when - PG 9.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi guys. How can I count using 'CASE WHEN'?

Example:
SELECT
CASE
        WHEN AND c.regdate > EXTRACT(epoch FROM (now() - INTERVAL '14 day'))
        THEN 'trial'
        WHEN last_pay > EXTRACT(epoch FROM (now() - INTERVAL '37 day'))
        THEN 'paying'
        END as account_status,
        c.id
    FROM public.clients c
        WHERE (
               (last_pay > EXTRACT('epoch' FROM now() - '12 Months'::INTERVAL))
              )
    ORDER BY 1 

I wanna know how many of 'trial' and 'paying' customers the query returns. can you guys please advice how to do it?

Thanks
Patrick

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux