>
> 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
