Re: Count dates distinct within an interval

Поиск
Список
Период
Сортировка
От greg@turnstep.com
Тема Re: Count dates distinct within an interval
Дата
Msg-id a71ba711731e88c9d58b295d45048dbe@biglumber.com
обсуждение исходный текст
Ответ на Count dates distinct within an interval  (Dmitry Tkach <dmitry@openratings.com>)
Список 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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: summing tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: summing tables