Hi,
Is it possible to use the output of explain as text values?
This won't work:
explain select *
from (values (1),(2),(3)) foo(x)
where x > 2
What i really want is to explain analyze a dynamic query that i build up in
a function.
If it returns a value i can do stuff with it, but i can't find out how to
grasp the query plan as a value.
pgAdmin shows it as text values in the data output tab, but that might be a
hack outside the database realm.
Cheers,
WBL
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth