"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().
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