> I thought we'd extracted all the interesting juice from the NIST tests
> a couple years ago. Specifically I recall this fix came out of NIST
> testing done by Red Hat:
>
> 2003-06-06 11:04 tgl
>
> Implement outer-level
> aggregates to conform to the SQL spec, with extensions to support
> our historical behavior. An aggregate belongs to the closest query
> level of any of the variables in its argument, or the current query
> level if there are no variables (e.g., COUNT(*)). The
> implementation involves adding an agglevelsup field to Aggref, and
> treating outer aggregates like outer variables at planning time.
I was just chatting with Neil C on IRC and he mentioned that back when
they were using it at RedHat, PostgreSQL didn't have schemas so most
stuff failed. Was just wondering if that's true and we need to re-run
them or something.
Chris