I have defined this table: CREATE TABLE market.price_history ( item_id bigint NOT NULL, valid_time tstzrange DEFAULT tstzrange(now(), 'infinity'), sale_price money NOT NULL, promo_code bool NO...

Is there a constraint or some other PostgreSQL feature that prevents CIDR columns from having values that overlap? For example: 192.168.1.0/24 and 192.168.1.1/32 These could not exist together b...

From PostgreSQL document Exclusion constraints ensure that if any two rows are compared on the specified columns or expressions using the specified operators, at least one of these operator co...

I am creating a database which stores arbitrary date/time ranges in PostgreSQL 9.2.4. I want to place a constraint on this database which forces the date/time ranges to be non-overlapping, and non-...