Selecting Two Correlated Rows and Showing the Opposite of the Correlated Field in PostgreSQL

Enforcing Uniqueness Across Multiple Columns in Postgres: A Bridge Table Approach