Re: Count dates distinct within an interval - Mailing list pgsql-sql

From greg@turnstep.com
Subject Re: Count dates distinct within an interval
Date
Msg-id a71ba711731e88c9d58b295d45048dbe@biglumber.com
Whole thread Raw
In response to Count dates distinct within an interval  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> Also, I could certainly write a simple function, that would get all the 
> entries in order, and scan through them, counting according to my rules...
> But I was hoping to find some way to do this in plain sql though...

In this example, you are best off using a function.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200307151137

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE/FCAgvJuQZxSWSsgRAg1jAJ9kS9PpIiMkij6TtOg63O59TeezPACgzhMF
ZM/84SEPP4doDR8fsGpnUBU=
=w5Wa
-----END PGP SIGNATURE-----



pgsql-sql by date:

Previous
From: Greg Stark
Date:
Subject: Re: summing tables
Next
From: Tom Lane
Date:
Subject: Re: summing tables