On Wed, Nov 3, 2021 at 7:49 AM Erki Eessaar <erki(dot)eessaar(at)taltech(dot)ee> wrote:
> Unfortunately the bodies of such routines are not visible in the column
> routine_definition of the view INFORMATION_SCHEMA.routines. In case of
> these routines the field contains the empty string instead of the routine
> body.
>
Thanks for the report!
The information schema query consults pg_proc.prosrc directly instead of
calling pg_get_functiondef(...) (which didn't exist when the original query
was written, and hasn't been wrong until now).
David J.