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