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.fr

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Fabien COELHO <coelho (AT) cri (DOT) ensmp.fr> writes:
regprocout doesn't schema-qualify if the function name is unique without
it.

Of course, the function name isn't necessarily unique *with* it, either,
but regproc can't do anything about that. Cast to regprocedure if you
want to see a more helpful display of the function.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Ok. Maybe too clever, as I couldn't guess by looking at it.

Much better indeed.

Thanks a lot for the light. Have a nice day.

--
Fabien Coelho - coelho (AT) cri (DOT) ensmp.fr

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org