"Jim C. Nasby" <decibel@decibel.org> writes:
> I'm also working on trying to do a select out of pg_proc, but I'm not
> having a lot of luck there either...
> # select oid,* from pg_proc where proname='user_write_lock_oid' and
> proargtypes = ARRAY((SELECT oid FROM pg_type WHERE
> typname='oid'))::oidvector;
> ERROR: cannot cast type oid[] to oidvector
For standard types like OID, it's probably easiest just to hardwire the
oidvector value:
select ...
where proname='user_write_lock_oid' and pronargs = 1 and proargtypes = '26';
Note you should include the pronargs test to allow this to match the
index on pg_proc.
regards, tom lane
