Re: Representing a SRF return column in catalogs

On Wed, Nov 5, 2014 at 8:24 AM, Atri Sharma <atri(dot)jiit(at)gmail(dot)com> wrote:
> 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.

It's not clear to me what you are trying to do, so I can't give you any advice.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company