mha@postgresql.org (Magnus Hagander) writes:
> Make the pg_stat_activity view call a SRF (pg_stat_get_activity())
> instead of calling a bunch of individual functions.
> This function can also be called directly, taking a PID as an argument, to
> return only the data for a single PID.
Hmm, if you really intend the function to be used directly, then having
to provide the output column list for it is a pretty big usability hit.
Why not declare it with OUT parameters, instead?
regards, tom lane