>
>
> Olá Matheus, obrigado pela dica, mas já tinha tentado com CASE e não
> funcionou.
>
>
>
> Mais alguém ?
>
talvez isso ajude
SELECT setor,SUM(total) AS total
FROM
(
SELECT 'PV' AS setor,
SUM(pagvalorprincipal) AS total
FROM pagamentos
WHERE pagdtpagamento IS NULL AND pagdtvencimento < data_atual
GROUP BY setor
UNION
SELECT 'PH' AS setor,
SUM(pagvalorprincipal) AS total
FROM pagamentos
WHERE pagdtpagamento IS NULL AND pagdtvencimento = data_atual
GROUP BY setor
UNION
SELECT 'PF' AS setor,
SUM(pagvalorprincipal) AS total
FROM pagamentos
WHERE pagdtpagamento IS NULL AND pagdtvencimento > data_atual
GROUP BY setor
) AS setores
right join unnest(ARRAY['PH','PV','PF']) on unnest = setor
GROUP BY setor
>
>
> Att,
>
> Paulo.
>
>
>
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
--
Dadilton Bastos Melo
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
