On 12/31/17 11:57, Tom Lane wrote: > 3. In connection with #2, I'm dubious that FUNCTION_NAME is le mot > juste, because that would seem to imply that it is just the name, > which it isn't. If we stick with the regprocedureout semantics > I'd be inclined to propose FUNCTION_SIGNATURE.
The SQL standard has diagnostics items ROUTINE_CATALOG, ROUTINE_SCHEMA, ROUTINE_NAME, which are used when there is an error invoking another routine. Using notionally similar FUNCTION_* keys to mean my own function seems pretty confusing (and also of questionable usefulness, as you have commented). -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
