couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "paul jobs" <webjog...@gmail.com>
Subject Re: Couchdb views using time
Date Fri, 09 Jan 2009 23:47:51 GMT
This is very useful for eg., to delete posts older than one day
get users who logged in the last 1 hour etc

On Fri, Jan 9, 2009 at 3:47 PM, paul jobs <webjogger@gmail.com> wrote:

> select * from users where ((extract('epoch' from now()) - extract('epoch'
> from last_login)) < 3000000) order by last_login DESC
>
> is it possible to construct such views using couchdb permanent views?
>
> thanks
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message