Re: pg_aggregate weird stuff

Alexander Cohen <alex(at)toomuchspace(dot)com> writes:
> Im trying to get a list of aggregate names. So i do "SELECT aggfnoid
> FROM pg_aggregate" to get a list of Oid of the functions. But this
> column seems to return names and not Oid's of the procs. Is this
> normal, how can i get a loist of proc Oid's for the aggregtates?

(1) Yes it is, see type regproc in the docs. (2) Cast to oid if
you want numeric output.

However, you might find it easier to look for pg_proc rows where
proisagg is true ... no join needed if you do that.

regards, tom lane