Jan-Peter.Seifert@xxxxxx writes: > Hello raf, >>> Easier is just >>> select oid::regprocedure from pg_proc where <whatever> >> note that this method doesn't produce a complete function >> signature. the precision and scale of numerics are not >> included in the output. hopefully, that won't matter for >> your needs. > Oh. So functions expecting e.g. numeric(5,2) as argument wouldn't be listed correctly? Is this going to be fixed then? No, because it's not broken. Precision/scale of numerics aren't relevant to function signatures. A function can take or return a numeric, full stop --- it doesn't matter what the precision is. The same goes for other type modifiers such as varchar maxlength. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
