• Tom Lane's avatar
    Rewrite interval_hash() so that the hashcodes are equal for values that · 1c2d408c
    Tom Lane authored
    interval_eq() considers equal.  I'm not sure how that fundamental requirement
    escaped us through multiple revisions of this hash function, but there it is;
    it's been wrong since interval_hash was first written for PG 7.1.
    Per bug #4748 from Roman Kononov.
    
    Backpatch to all supported releases.
    
    This patch changes the contents of hash indexes for interval columns.  That's
    no particular problem for PG 8.4, since we've broken on-disk compatibility
    of hash indexes already; but it will require a migration warning note in
    the next minor releases of all existing branches: "if you have any hash
    indexes on columns of type interval, REINDEX them after updating".
    1c2d408c
interval.out 21.3 KB