• Tom Lane's avatar
    Teach planagg.c that partial indexes specifying WHERE foo IS NOT NULL can be · 106264ca
    Tom Lane authored
    used to perform MIN(foo) or MAX(foo), since we want to discard null rows in
    the indexscan anyway.  (This would probably fall out for free if we were
    injecting the IS NOT NULL clause somewhere earlier, but given the current
    anatomy of the MIN/MAX optimization code we have to do it explicitly.
    Fortunately, very little added code is needed.)  Per a discussion with
    Henk de Wit.
    106264ca
planagg.c 18.1 KB