Substring Problem

[Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>]

Hi there,

it seems to work with 8.1, but not anymore with 8.3. What is wrong with this substring request? Or is it some installation issue? Thanks for any suggestion!

SELECT substring(date from 1 for 7) AS stryearmonth, COUNT(id) AS countofnumber FROM (SELECT * from downloads ) AS foo GROUP BY stryearmonth ORDER BY stryearmonth ASC

It says:

ERROR:  function pg_catalog.substring(date, integer, integer) does not exist
LINE 1: SELECT substring(date from 1 for 7) as stryearmonth, COUNT(i...