Postgres Pro
Downloads
Home   >   mailing lists

Re: interval query. - Mailing list pgsql-sql

From Blaise Carrupt
Subject Re: interval query.
Date
Msg-id 200101311206.MAA22252@mjtsa.com
Whole thread Raw
In response to interval query.  (Antti Linno <alligator@all.ee>)
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: Antti Linno
Date:
Subject: interval query.
Next
From: Som
Date:
Subject: Image insertion by using BLOB