How to join several selects - Mailing list pgsql-sql

From Josep Sanmartí
Subject How to join several selects
Date
Msg-id 430C7A21.9020306@openwired.net
Whole thread Raw
Responses Re: How to join several selects  (Sean Davis <sdavis2@mail.nih.gov>)
Re: How to join several selects  (Rod Taylor <pg@rbt.ca>)
Re: How to join several selects  (Zac <zaccheob@inwind.it>)
List pgsql-sql
Hello,
I have a 'big' problem:
I have the following table users(name, start_time, end_time), a new row 
is set whenever a user logs into a server.  I want to know how many 
users have logged in EVERYDAY between 2 different dates. The only idea 
that I have is making several select (one for each day):   SELECT COUNT(name) FROM users WHERE start_time between
"startDate"
 
and "startDate+1"   SELECT COUNT(name) FROM users WHERE start_time between "startDate+1" 
and "startDate+2"   ...
I would like to know if its possible to make it in 1 sql statement or 
just which is the best efficient way to solve it.
By the way, I use Postgres 7.4.

Thanks!

-- 
Josep Sanmarti
Analista de Projectes

Grup OpenWired, S.L.
Caballero, 87 - 08029 - Barcelona (Spain)
Tel (+34) 93/410 75 70 - Fax (+34) 93/419 45 91



pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Number of rows in a cursor ?
Next
From: Sean Davis
Date:
Subject: Re: How to join several selects