Tags: SQL

  • Implementing Mutual Exclusion Constraints with Exclude

    April 06, 2018 in PostgreSQL

    Implementing Mutual Exclusion Constraints with Exclude

    Exclude constraint is a PostgreSQL extension that can implement more advanced and sophisticated database constraints.

    Exclude constraint is a PostgreSQL extension that can implement more advanced and sophisticated database constraints.

  • Distinct On: Remove Duplicate Data

    April 06, 2018 in PostgreSQL

    Distinct On: Remove Duplicate Data

    Use Distinct On extension clause to quickly find records with maximum/minimum values within groups

    Use Distinct On extension clause to quickly find records with maximum/minimum values within groups