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