Re: Count dates distinct within an interval

From: greg(at)turnstep(dot)com
To: pgsql-sql(at)postgresql(dot)org
Cc: dmitry(at)openratings(dot)com
Subject: Re: Count dates distinct within an interval
Date: 2003-07-15 15:40:52
Message-ID: a71ba711731e88c9d58b295d45048dbe@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200307151137

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

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-07-15 15:42:03 Re: summing tables
Previous Message Greg Stark 2003-07-15 15:38:21 Re: summing tables