incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Anderson" <jch...@gmail.com>
Subject Re: Couchdb views using time
Date Sat, 10 Jan 2009 06:52:41 GMT
just have a map view that calls emit(doc.timestamp, null) as long as
your timestamp format sorts correctly.

On Fri, Jan 9, 2009 at 3:47 PM, paul jobs <webjogger@gmail.com> wrote:
> 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
>>
>



-- 
Chris Anderson
http://jchris.mfdz.com

Mime
View raw message