2012/7/26 Dilson Tomé <[email protected]>:
>
> 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"

Nem sempre tem-se tempo para analisar código pouco identado assim.
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a