Обсуждение: pg_aggregate weird stuff

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?

thanks!
--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443

Alexander Cohen <alex@toomuchspace.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