In postgres 9.2 a new family of data types were added called Ranges. This is a quick overview of how to use them. Range Types There are a handful of built in range types that cover the expected number and date types and you can also define your own if you need something outside of that. Basic Operations Defining Range - CREATE TABLE ranges (range int4range) Inserting Range - INSERT INTO ranges VALUES(’[1, 4]') Infinate Ranges - INSERT INTO ranges VALUES(’[4, infinity]') Check Range Member...
