Hi Tom, >If you don't need that, why are you insistent on extracting the >information from a plan tree?
I need to resolve expressions and apply rewrite rules before I reverse the query plan to a query. >It seems far simpler to me to make use of ruleutils.c to reverse-list >the original parsetree. That functionality already exists and is well >tested and well maintained. If you insist on working from a plan tree, >you will be writing a fair amount of code that you will have to maintain >yourself. And I absolutely, positively guarantee that we will break it >in every major release, and occasionally in minor releases. You should >read the git history of explain.c and ruleutils.c and ask yourself whether >you want to keep up with that level of churn. I'm aware of ruleutils.c which I think is a good tool but I don't think it's appropriate as it takes the parse tree as input. Best, Mariem -- View this message in context: http://postgresql.1045698.n5.nabble.com/Convert-query-plan-to-sql-query-tp5825727p5826175.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
