>If what you're wishing for is that you could also capture the effects >of planner steps that are in the nature of source-to-source >transformations, I think that's going to be harder because no great >effort has been made to keep those at arm's length from steps that >don't have results describable as pure SQL. However, you could probably >get pretty far if you applied ruleutils.c to the modified parse tree >after the constant-folding and join tree simplification phases.
I'm not sure if I understand what you mean by source-to-source transformations. But yes, what I'm aiming is applying simplification phases and constant-folding before transforming the query tree back to sql text query. Thank you for the suggestions. Best, Mariem -- View this message in context: http://postgresql.nabble.com/Convert-query-plan-to-sql-query-tp5825727p5826448.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