"Jim Buttafuoco" <[EMAIL PROTECTED]> writes: > select 'drop function ' || nspname || '.' || proname || '(' || > pg_catalog.oidvectortypes(p.proargtypes) || ');' from > pg_proc p join pg_namespace b on (p.pronamespace=b.oid) where > nspname='public';
Seems like you could do that more easily with regprocedure: select 'drop function ' || p.oid::regprocedure || ';' from pg_proc p join pg_namespace b on (p.pronamespace=b.oid) where nspname='public'; [ tries it ... ] ... except that there's no regprocedure-to-text cast. How annoying :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match