TODO has an entry o Allow UPDATE to handle complex aggregates [update]?
which I think is now obsolete, because we've settled on rejecting aggregates at the top level of UPDATE, as the spec tells us to do. Also, there's one remaining unfinished feature in the multi-argument aggregate patch, which I think we should have a TODO item for: * Allow DISTINCT to work in multiple-argument aggregate calls The SQL2003 spec doesn't require this (it forbids DISTINCT in all its two-argument aggregates) but it seems like we should do it someday for orthogonality's sake. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend