Wells Oliver <wells(dot)oliver(at)gmail(dot)com> writes:
> I've inherited a DB with a lot of legacy functions and aggregates that have
> an SFUNC of array_append and an STYPE of anyarray.
> Is there some way I can query for these aggregates/functions and see how
> many I need to drop and have available to replace after a
> successful upgrade?
Something like
select aggfnoid::regprocedure from pg_aggregate where aggtransfn = 'array_append'::regproc;
regards, tom lane