Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of sebastiancohnen@googlemail.com
 designates 209.85.218.221 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=content-type:mime-version:subject:from:in-reply-to:date
         :content-transfer-encoding:message-id:references:to:x-mailer;
        b=Hb4mmtSCkFJid80hvbGcVbAz6nxPhcfPNPLDfk9ApPeFkVZ2SBh+Y+PJ9lXXBBrpJz
         Ar+E8+m0xcgq6KSINpGZn2SlyoQMdTtSt5WSUsBN6XB9eN5+mMNTYkEcZqLIqRPo7Z3X
         pyMM/xPf9xwYc8/4R9j1tBcEaTnPLo/VgWfeg=
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1078)
Subject: Re: Search for city by name, order by population
From: Sebastian Cohnen <sebastiancohnen@googlemail.com>
In-Reply-To: <w2pdbe081211004120125hcc3bbd24xffa4f4f083699363@mail.gmail.com>
Date: Mon, 12 Apr 2010 10:31:30 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <227A0267-AA3C-4E4A-B7BF-6E3DDBD19AED@googlemail.com>
References: <w2pdbe081211004120125hcc3bbd24xffa4f4f083699363@mail.gmail.com>
To: user@couchdb.apache.org

hmm, I do not quite follow... isn't the name of the city unique? what do =
you mean by *searching* for a city?

On 12.04.2010, at 10:25, Magnus Ottosson wrote:

> Hi,
>=20
> I have a database with the names and population of cities (about 7
> million entities). Is it possible, with couchdb, to create a key that
> includes both cityname and population where I can search for a name
> and get the matching results ordered by the population?
>=20
> I tried to create a key like [population, name] and search like this
> ?startkey=3D[0, "name"]&endkey=3D[10000000, "name]&limit=3D10 but it =
does
> not work like the way I hoped.
>=20
> Any ideas?
>=20
> Magnus