Horton

Re:

Dan Langille <dan@langille.org>

View thread View on postgr.es
From: "Dan Langille" <dan@langille.org>
To: Jean-Luc Lachance <jllachan@nsd.ca>
Cc: Dan Langille <dan@langille.org>, pgsql-sql@postgresql.org
Date: 2003-09-29T21:19:04Z
Lists: pgsql-sql 
On 29 Sep 2003 at 10:04, Jean-Luc Lachance wrote:

> Wouldn't:
> 
> insert into r 
> select count(*) 
> from users 
> where date( lastlogin) > current_date - MaxDays * interval '' 1 day''
> group by date( lastlogin);
> 
> be more efficient?


Yes it would, by a factor of 5.

P.S. but it would not show dates for which there are no logins.  The 
above can return zero rows.  The previous example always returns 
MaxDays rows.
-- 
Dan Langille : http://www.langille.org/