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