Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 53661 invoked from network); 1 Nov 2009 16:43:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 1 Nov 2009 16:43:03 -0000 Received: (qmail 34602 invoked by uid 500); 1 Nov 2009 16:43:01 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 34517 invoked by uid 500); 1 Nov 2009 16:43:01 -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 34507 invoked by uid 99); 1 Nov 2009 16:43:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 01 Nov 2009 16:43:00 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of b.candler@pobox.com designates 208.72.237.25 as permitted sender) Received: from [208.72.237.25] (HELO sasl.smtp.pobox.com) (208.72.237.25) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 01 Nov 2009 16:42:58 +0000 Received: from sasl.smtp.pobox.com (unknown [127.0.0.1]) by a-pb-sasl-quonix.pobox.com (Postfix) with ESMTP id 869F86F68B; Sun, 1 Nov 2009 11:42:37 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=pobox.com; h=date:from:to :cc:subject:message-id:references:mime-version:content-type :in-reply-to; s=sasl; bh=apfkUizQJ129EWgje3cyadLuSQ8=; b=xUqlH9a RKVXdD5eWwF5ztgvdsaMs+SS4LaIz9KUZSwJxZ0axk6on9uRJAowY4Ww9bF4OGbv ky77S3SpEziSBgUuSQcNMXHx5ph5gPUjmKrhdD+/bE27oYwiy5EdO6ymYxxCG2ds gx+3AMn1gqKqlo5FkJIM38UcAz1DxXo9A3ew= DomainKey-Signature: a=rsa-sha1; c=nofws; d=pobox.com; h=date:from:to:cc :subject:message-id:references:mime-version:content-type :in-reply-to; q=dns; s=sasl; b=YN3TVTNRF3tfl7gJ+jKUuBquyXLvTqWO6 Wb+azGoIQyMk1S2m3/Ipx+D9LFbHZtVw00B4yA/2o5kTQkLGbZDN+5kKl2vuUUrw 70Dipn8u4QhiWMFi3iduiJQktTiahtvHOc0CbU1dScVPUilU1I7UzCkrCLu1u+cx JhvoNZnCBE= Received: from a-pb-sasl-quonix. (unknown [127.0.0.1]) by a-pb-sasl-quonix.pobox.com (Postfix) with ESMTP id 686A56F68A; Sun, 1 Nov 2009 11:42:36 -0500 (EST) Received: from mappit (unknown [80.45.95.114]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by a-pb-sasl-quonix.pobox.com (Postfix) with ESMTPSA id 132796F688; Sun, 1 Nov 2009 11:42:35 -0500 (EST) Received: from brian by mappit with local (Exim 4.69) (envelope-from ) id 1N4dVh-00048d-Er; Sun, 01 Nov 2009 16:42:33 +0000 Date: Sun, 1 Nov 2009 16:42:33 +0000 From: Brian Candler To: Norman Barker Cc: user@couchdb.apache.org Subject: Re: view key boolean operator Message-ID: <20091101164233.GA15845@uk.tiscali.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Pobox-Relay-ID: 8F803180-C705-11DE-91EA-1B12EE7EF46B-28021239!a-pb-sasl-quonix.pobox.com On Sat, Oct 31, 2009 at 04:21:16PM -0600, Norman Barker wrote: > Hi, > > is there a way to specify a key for a view such that the view returns > all results that don't have that key? > > e.g. myview?key="~a", returns all documents with keys equal to b, c, d, ... If every document emits at least one key, then you could query twice: once for key < a, and once for key > a. You should be able to do this using some combination of startkey, endkey, desc and/or inclusive_end.