From: | Jie Liang <jliang(at)ipinc(dot)com> |
---|---|
To: | Antti Linno <alligator(at)all(dot)ee> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: interval query. |
Date: | 2001-01-31 17:48:20 |
Message-ID: | Pine.BSF.4.10.10101310946410.37554-100000@tidal.ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)ipinc(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rick Delaney | 2001-01-31 18:44:16 | Re: Permissions for foreign keys |
Previous Message | Mark Volpe | 2001-01-31 17:42:01 | Re: Index scan |