Received: from mjtsa.com (mjtgtw2.mjt.ch [194.209.241.21]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0VB6Bq29769 for ; Wed, 31 Jan 2001 06:06:12 -0500 (EST) (envelope-from bc@mjtsa.com) Received: (from bc@localhost) by mjtsa.com (8.9.2/dc) id MAA22252 for pgsql-sql@postgresql.org; Wed, 31 Jan 2001 12:06:30 GMT Date: Wed, 31 Jan 2001 12:06:30 GMT From: Blaise Carrupt Message-Id: <200101311206.MAA22252@mjtsa.com> To: pgsql-sql@postgresql.org Subject: Re: interval query. Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-MD5: 1UhPzI4xmssL8p5byRGdqg== X-Archive-Number: 200101/470 X-Sequence-Number: 1146 > Is there some way to make interval query? > > 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? > This should work : WHERE id = 9999 OR id BETWEEN(3 AND 12). Regards ______________ B. Carrupt