• Tom Lane's avatar
    Recognize functional dependency on primary keys. This allows a table's · e49ae8d3
    Tom Lane authored
    other columns to be referenced without listing them in GROUP BY, so long as
    the primary key column(s) are listed in GROUP BY.
    
    Eventually we should also allow functional dependency on a UNIQUE constraint
    when the columns are marked NOT NULL, but that has to wait until NOT NULL
    constraints are represented in pg_constraint, because we need to have
    pg_constraint OIDs for all the conditions needed to ensure functional
    dependency.
    
    Peter Eisentraut, reviewed by Alex Hunsaker and Tom Lane
    e49ae8d3
queries.sgml 63.6 KB