What does exclusion constraint `EXCLUDE USING gist (c WITH &&)` mean?
Whereas a CHECK constraint evaluates an expression based on a single row of the table, an EXCLUDE constraint evaluates a comparison of two rows in the table. Think of it like a generalised UNIQUE constraint: instead of “no two rows can be equal”, you can say things like “no two rows overlap”, or even “no … Read more