finding gaps in dates
От | Matt Nuzum |
---|---|
Тема | finding gaps in dates |
Дата | |
Msg-id | 27c475ec04111612561a696fd1@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: finding gaps in dates
|
Список | pgsql-sql |
I have a logging application that should produce an entry in the database every minute or so, give or take a few seconds. I'm interested in finding out a: what minutes don't have a record and b: periods where the gap exceeded a certain amount of time. The only way I can think of to do it is to create a set returning function that accepts a begin and end date and returns a date_trunc('minute', ...) for each minute between then and then doing Select ts from srf(now() - '30 days'::inteval, now()) where ts not in (select distinct date_trunc('minute', ts) from table where ts between now() - '30 days'::inteval and now()); Of course, that seems extremely tedious to me (not tedious to code, but tedious for the db to process). If anyone can suggest a better way I'd really appreciate it. -- Matthew Nuzum | Makers of "Elite Content Management System" www.followers.net | View samples of Elite CMS in action matt@followers.net | http://www.followers.net/portfolio/
В списке pgsql-sql по дате отправления: