[GENERAL] Substring Problem

[Stefan Schwarzer]

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