Hi, I am working on something that requires representing a SRF return column in pg_proc and being able to retrieve it, retrieve the name of the column and make a ColumnRef node from it.
The catch here are aliases: SELECT generate_series(1,100) AS a ORDER BY a; I need to know that the return column of generate_series is being referred as a in this query (hence tlist, sortClause will have 'c'). I discussed and think that a way can be to have position of column rather than the actual name but that raises the question of the functionality needed for back resolving position to name (to make a ColumnRef node) and then infer that the column is being referred as an alias in this query. Any pointers will be really helpful. Regards, Atri