How to return all entries "from the current year"?...

Perform this hours of operation query in PostgreSQL...

Non-overlap, continuous timestamp ranges (tstzrange) for opening hours...

Preventing adjacent/overlapping entries with EXCLUDE in PostgreSQL...

How do I create an custom range type in PostgreSQL for example from 1 to 100?...

Compute an aggregated tsrange from a set of entries?...

How to use the NOW() function as upper bound of a range?...

tsrange or daterange for sqlite?...

PostgreSQL tsrange: is it correct for lower_inf('(-infinity,today)'::tsrange) to be false?...

Fast table indexing for range lookup...

PostgreSQL tsrange -- overlap ignores equivalent ranges?...

Procedure for metaquery in pure SQL / PostgreSQL...

Matching overlapping daterange values in PostgreSQL 9.3...

Count visits on a daily base with one select...

Best way to join on a range?...

Ada-style Range Types in D...

How to create a daterange in PostgreSQL using Rails...