Foi errado...
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"
FROM generate_Series(0,6) i;
--! *Dilson Tomé Rainov*
*Skype: dilsontome*
*MSN: [email protected]*
*(11) 8013-7803*
On Thu, Jul 26, 2012 at 2:16 PM, Dilson Tomé <[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"
>
>
>
> --! *Dilson Tomé Rainov*
> *Skype: dilsontome*
> *MSN: [email protected]*
> *(11) 8013-7803*
>
>
>
>
> On Thu, Jul 26, 2012 at 2:14 PM, Dilson Tomé <[email protected]> wrote:
>
>> Como?
>> rs
>>
>>
>>
>> --! *Dilson*
>>
>>
>>
>>
>> On Thu, Jul 26, 2012 at 2:11 PM, Guimarães Faria Corcete DUTRA, Leandro <
>> [email protected]> wrote:
>>
>>> 2012/7/26 Dilson Tomé <[email protected]>:
>>> >
>>> > postgres=# 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"
>>> > FROM generate_Series(0,6) i;
>>>
>>> Identa…
>>> _______________________________________________
>>> 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
