> So the short version: Given the RTE for a simple view with only one base > rel and an attribute number for a col in that view, and assuming that > the view col is a simple reference to a col in the underlying base rel, > is there any sane way to get the attribute number for the corresponding > col on the base rel?
So, of course, I find it as soon as I post.
map_variable_attnos(...), also in src/backend/rewrite/rewriteManip.c .
Just generate the mapping table and go.
Could you please explain a little bit more how would you solve the posed problem using map_variable_attnos?
I was recently working on a similar problem and used the following algo to solve it.
I had to find to which column of the base table does a column in the select statement of the view query belong.
To relate a target list entry in the select query of the view to an actual column in base table here is what I did
First determine whether the var's varno refer to an RTE which is a view?
If yes then get the view query (RangeTblEntry::subquery) and see which element in the view query's target list does this var's varattno point to.
Get the varno of that target list entry. Look for that RTE in the view's query and see if that RTE is a real table then use that var making sure its varno now points to the actual table.
Thanks in advance.
Sorry for the noise folks. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services