Re: [SQL] grouping by date increments

2001-01-23 Thread Tom Lane
"Graham Vickrage" <[EMAIL PROTECTED]> writes: > I have written this successfully but need to get the count in time > increments such as per day/week/month. Perhaps use GROUP BY date_part(...). See stgresql.org/devel-corner/docs/postgres/functions-datetime.htm for doco on date_part().

[SQL] grouping by date increments

2001-01-23 Thread Graham Vickrage
I am trying to write a select statement to count the occurences of a particular string between a set of dates. I have written this successfully but need to get the count in time increments such as per day/week/month. At the moment I am doing a select for each increment seperately but figure that