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 14:54:41 |
Message-ID: | 7f2298d39c75726c835ecbf42f0c8e70@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> Now, I want to count the occurences of each value of stuff in the table,
> but so that entries within 24 hours from each other count as one...
>...
> A = 2001 - 01- 01 20:20:00
> B = 2001 - 01 - 02 20:19:00
> C = 2001 - 01 - 02 20:21:00
> Should be counted as *two* (A === B, and B === C, but *not* A === C)...
You need to elaborate on your logic some more, and state exactly what you
would want in the A,B,C case above. Does B get lumped with A or with C?
It is within 24 hours of both, after all. Does C not get lumped in with
B simply because B has already been lumped in with A?
Perhaps showing us the sample output of an ideal query would be best,
along with some sample rows (e.g. use real insert statements)
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200307151045
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html
iD8DBQE/FBS9vJuQZxSWSsgRAnk3AJ0bqyDk6iZWqSZuHfZslFCjxwl7fgCfaZ7r
XdwpPsO4OaTa9YpjmXx1hmA=
=IFRz
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Haller | 2003-07-15 14:54:48 | Re: Non-Blocking Locks (i.e. Oracle NOWAIT) |
Previous Message | Dmitry Tkach | 2003-07-15 14:43:02 | Re: Cannot insert dup id in pk |