How much effort would it be to add EXPLAIN/EXPLAIN ANALYSE capability to pl/pgsql functions?
what I mean, is either a special mode, where "SELECT my_plpgsql_func()" would print all query plans instead or in addition to executing them, or some way for EXPLAIN to pass some flags to functions so that they can "do the right thing". Hannu ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate