On Mon, Jul 8, 2013 at 2:18 PM, Andreas wrote:
> How could I combine those 2 queries so that the date in query 1 would be
> replaced dynamically with the result of the series?
>
Surely I'm missing something, but maybe this is something to work on:
WITH
RECURSIVE months(number) AS ( SELECT 1 UN
Hi,
I need to show a moving statistic of states of objects for every month
since beginning of 2013.
There are tables like
objects ( id integer, name text );
state ( id integer, state text ); 10=A, 20=B ... 60=F
history ( object_id integer, state_id, ts timestamp );
Every event that
