Doug Gorley <doug.gorley@gmail.com> writes:
> The statement I need to generate is:
> revoke all on function public.add(integer, integer) from someuser;
> I'm attempting to use the pg_proc table in the system catalogs, and I'm
> good up to the point where I need the parameter types. Can anyone give
> me a hand with this?
Personally, I'd cast the function OID to regprocedure, instead of
doing it the hard way ...
regards, tom lane