Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 33916 invoked from network); 9 Jan 2009 23:48:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Jan 2009 23:48:21 -0000 Received: (qmail 74494 invoked by uid 500); 9 Jan 2009 23:48:19 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 74456 invoked by uid 500); 9 Jan 2009 23:48:19 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 74445 invoked by uid 99); 9 Jan 2009 23:48:19 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Jan 2009 15:48:19 -0800 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of webjogger@gmail.com designates 209.85.128.189 as permitted sender) Received: from [209.85.128.189] (HELO fk-out-0910.google.com) (209.85.128.189) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Jan 2009 23:48:13 +0000 Received: by fk-out-0910.google.com with SMTP id k31so6369188fkk.11 for ; Fri, 09 Jan 2009 15:47:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=F6Dwkaxt2Jdph/Aq+JXgWnLdwjhn6yQbMsG7W4j0puE=; b=NSJVE3zUJhFKPtVWE2kvPUFrxFfK/EuRYaZg6Xa0OFe9QAMPnewBSqd/3HvNZzIhdw L5Nj2P4LjuiIIuCtze+z1ygGFWOOnykrlErzXtmX7T8df3iIZZk767CELWmpo9TkMJDX k3i0kFHZ4OCfGPYsWe3z21ElP/BEXLhgI0IfU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=DqwrFlyLOAMcjCy2KDgQrIDRvtRHKH4PHd+XblOczWwkpuuvbmTv0sz6L8CdeIct+E 1d4RuEvI4uxBSbvrAYuSEDfIk8rD1zdnwYVfRqf7BNEnobk9bDs6UdiqXuv4gWHjkC3n 1tRwEPTAPZsv24MTY/kU7GxdgQPE1fUpMUmno= Received: by 10.103.182.3 with SMTP id j3mr9398666mup.107.1231544871733; Fri, 09 Jan 2009 15:47:51 -0800 (PST) Received: by 10.103.246.16 with HTTP; Fri, 9 Jan 2009 15:47:51 -0800 (PST) Message-ID: <4c69d7170901091547g2a42a2ccnccfdc38482b4e5c4@mail.gmail.com> Date: Fri, 9 Jan 2009 15:47:51 -0800 From: "paul jobs" To: user@couchdb.apache.org Subject: Re: Couchdb views using time In-Reply-To: <4c69d7170901091547w6f43b7c1wf9612ff459ba8c7a@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_214839_23685061.1231544871732" References: <4c69d7170901091547w6f43b7c1wf9612ff459ba8c7a@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_214839_23685061.1231544871732 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 > ------=_Part_214839_23685061.1231544871732--