Received: from all.all.ee (puu.all.ee [194.204.49.113]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0V9hXq24785 for ; Wed, 31 Jan 2001 04:43:38 -0500 (EST) (envelope-from alligator@all.ee) Received: from localhost (localhost [127.0.0.1]) by all.all.ee (8.9.3/8.9.3) with ESMTP id LAA04041 for ; Wed, 31 Jan 2001 11:43:29 +0200 Date: Wed, 31 Jan 2001 11:43:29 +0200 (EET) From: Antti Linno To: pgsql-sql@postgresql.org Subject: interval query. Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200101/469 X-Sequence-Number: 1145 Good morning. Is there some way to make interval query? Towns table(estonia towns, heh :P) id | name 1 Elva 2 Tartu 9999 Tallinn 3 Tallinn/Haabersti 4 Tallinn/Mustamae ... etc. What I need is when the town's id=9999 I want to make query where id=9999 OR id=[3..12] for example. I could generate bunch of OR's like id=3 OR id=4 ... but is there some more elegant solution? Greetings, Antti