From: | Atri Sharma <atri(dot)jiit(at)gmail(dot)com> |
---|---|
To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Representing a SRF return column in catalogs |
Date: | 2014-11-05 13:24:48 |
Message-ID: | CAOeZVic5STWa=qoRTa4M2kmf8spjeFmARScA8oU6OpRR3a3Gyw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2014-11-05 14:29:56 | Re: get_cast_func syscache utility function |
Previous Message | Alvaro Herrera | 2014-11-05 12:46:00 | Re: WAL replay bugs |