Marco Lazzeri wrote:
> Does exist a syntax in PostgreSQL for integer (INT) number ranges?
>
> It could be useful for queries like
> "SELECT * FROM table WHERE id IN (range from 1 to 20)"
I believe you're looking for BETWEEN:
SELECT * FROM table WHERE id BETWEEN 1 AND 20;
That is standard SQL and not specific to PostgreSQL
Greg
