Postgres Pro
Downloads
Home   >   mailing lists

Thread: interval query.

interval query.

From
Antti Linno
Date:
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

Re: interval query.

From
Blaise Carrupt
Date:
> 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

Re: interval query.

From
Mark Volpe
Date:
Try

SELECT * FROM Towns WHERE id=9999 OR id BETWEEN 3 AND 12


Antti Linno wrote:
> 
> 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

Re: interval query.

From
Jie Liang
Date:
Hi,

where id=9999 or id between 3 and 12;

or

where id in (3,4,5,6,7,8,9,10,11,12,9999);

Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com

On Wed, 31 Jan 2001, Antti Linno wrote:

> 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
> 
>