I've noticed a minor inconsistency when listing pg_aggregate in
current 8.0.0beta1 version.
psql> SELECT aggfnoid FROM pg_aggregate;
4 functions are not schema qualified:
count
bool_and
bool_or
every
although all others are shown with a schema name:
pg_catalog.avg
pg_catalog.sum
pg_catalog.max
pg_catalog.min
...
However psql \da show all of them in pg_catalog, as expected.
I cannot see the difference in the initialization script to explain that.
Maybe something wrong with the regproc type?
--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr