Simon Riggs <si...@2ndquadrant.com> writes: > On 20 March 2013 18:02, Tom Lane <t...@sss.pgh.pa.us> wrote: >> The API that comes to mind is (name subject to >> bikeshedding) >> >> pg_blocking_pids(pid int) returns int[]
> Useful. Can we also have an SRF rather than an array? I thought about that, but at least for the isolationtester use-case, the array result is clearly easier to use. You can get from one to the other with unnest() or array_agg(), so I don't really feel a need to provide both. Can you generate use-cases where the set-result approach is superior? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers