Aí sim... Sempre aprendo... Muito obrigado!!!
--! *Dilson* On Thu, Jul 26, 2012 at 2:18 PM, Vinicius Santos < [email protected]> wrote: > Lá vai >> >> SELECT to_char(((date_trunc('week',current_date)::date) + (i+6)), 'DAY') >> AS "DATA", >> CASE >> to_char(((date_trunc('week',current_date)::date) + (i+6)), 'DAY') WHEN '* >> SUNDAY*' THEN '*FIM DE SEMANA*' WHEN '*SATURDAY*' THEN '*FIM DE >> SEMANA*' ELSE '*DIA UTIL*' END AS "TENTATIVA" >> >> >> > > Coloque um TRIM, assim: > > SELECT > to_char(((date_trunc('week',current_date)::date) + (i+6)), 'DAY') AS > "DATA", > CASE TRIM( to_char(((date_trunc('week',current_date)::date) + (i+6)), > 'DAY' )) > WHEN 'SUNDAY' THEN > 'FIM DE SEMANA' > WHEN 'SATURDAY' THEN > 'FIM DE SEMANA' > ELSE > 'DIA UTIL' > END AS "TENTATIVA" > FROM generate_series( 0, 6 ) i; > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > >
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
