Re: Select

That is so strange. Ok, now I ran it on the test data. But I get 15
rows if I run:

SELECT count(*),to_char(r.created,'YYYY-MM-DD') as d FROM requests r
WHERE r.oid NOT IN (SELECT DISTINCT u1.oid FROM requests u1 JOIN
requests u2 USING (client_ip, host, uri, referer, agent) WHERE
u1.oid<>u2.oid AND (u1.created-u2.created)<='00:00:01' AND
(u1.created-u2.created)>='-00:00:01') GROUP BY d ORDER BY d

And on other (real data) I do not get any rows at all.

Which version of postgresql are you using? I use:

select version();
version
-------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.7 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc
(GCC) 3.3.5 (Debian 1:3.3.5-12)
(1 row)

.