https://davidhampgonsalves.com/tags/postgresql/Recent content in Postgresql on David Hamp-GonsalvesHugo -- gohugo.ioen-USTue, 18 Mar 2014 00:00:00 +0000https://davidhampgonsalves.com/postgresql-range-basics/Tue, 18 Mar 2014 00:00:00 +0000https://davidhampgonsalves.com/postgresql-range-basics/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 Membership - SELECT * FROM ranges where range @> 2 Get Range Bounds - SELECT lower(range), upper(range) FROM ranges Defining Ranges Values You can define inclusive ranges using [2,3] and exclusive ranges using (1,4).