interval query.

From: Antti Linno <alligator(at)all(dot)ee>
To: pgsql-sql(at)postgresql(dot)org
Subject: interval query.
Date: 2001-01-31 09:43:29
Message-ID: Pine.LNX.4.04.10101311137420.1158-100000@all.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Som 2001-01-31 11:20:10 Image insertion by using BLOB
Previous Message Michael Davis 2001-01-31 07:32:05 RE: Rownum/ row Id