Valeu Euler...
2013/2/27 Euler Taveira <eu...@timbira.com>
> On 27-02-2013 16:39, Marcelo da Silva wrote:
> > Pessoal como fazer neste caso, tenho o seguinte select
> >
> > select z.*, (a_pagar + a_receber) as diferenca from(
> > select
> > concat(extract(month from a.data_ven),'/', extract(year from
> a.data_ven))
> > as periodo,
> > -coalesce(sum(c.val_doc), 0) as a_pagar,
> > coalesce(sum(d.val_doc), 0) as a_receber
> > from mv_contas_pagrec a
> > inner join mv_historicos b on(b.cod_his = a.cod_his)
> > left join mv_contas_pagrec c on(c.cod_key = a.cod_key)and(c.c = 'P')
> > left join mv_contas_pagrec d on(d.cod_key = a.cod_key)and(d.c = 'R')
> > where (a.obs not in('C'))
> > and(a.data_ven between '01/09/2012' and '31/01/2013')
> > and(a.data_qui is null)
> > and(a.pedido_ren <= 0)
> > group by
> > 1
> > order by
> > 1
> > ) as z
> >
> substitua 'order by 1' por:
>
> order by extract(year from a.data_ven), extract(month from a.data_ven)
>
>
> --
> Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
> PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
> _______________________________________________
> pgbr-geral mailing list
> pgbr-geral@listas.postgresql.org.br
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
