Re: Substring Problem

[Sam Mason <sam(at)samason(dot)me(dot)uk>]

On Tue, May 13, 2008 at 03:26:57PM +0200, Stefan Schwarzer wrote:
> 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

Another way of doing this is by using date_trunc, i.e.:

  SELECT date_trunc('month',date) AS yearmonth...

I think it'll still realise it can use indexes (if they're appropriate)
that way.


  Sam