Re: Substring Problem

[Tino Wildenhain <tino@xxxxxxxxxxxxx>]

ludwig@xxxxxxxxxxxxx wrote:
> Type casting is required since 8.3, try
>
> SELECT substring(date :: varchar from 1 for 7) AS stryearmonth, 
                     ^^^^^^

sorry but this hurts and should not recommended. I think depesz
approach with to_string() and the correct format string is the
better solution. (think of datetyle oddities) - one of the reasons
I believe most of the implicit casts have gone ayway.

> COUNT(id) AS countofnumber FROM (SELECT * from downloads ) AS foo GROUP 
> BY stryearmonth ORDER BY stryearmonth ASC

btw, whats the reason for the subselect?

T.

<<attachment: smime.p7s>>