Re: [pgbr-geral] Ordenar String como data

2013-02-27 Thread Euler Taveira 
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

Re: [pgbr-geral] Ordenar String como data

2013-02-27 Thread Marcelo da Silva 
Valeu Euler...

2013/2/27 Euler Taveira 

> 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