Good afternoon,
is it possible to create unique column names or to give column names
inside the parser phase that do not interfer with the outside world,
i.e. with column names from tables or aliases given by the user.
Some short background:
I created my own from-clause-item, that gets rewritten into a sub-query.
I do this because I want to re-use existing code as much as possible.
The rewritten sub-query gets transformed with "transformRangeSubselect"...
Within this sub-query I need 3 columns that shouldn't interfer with
columns from the input. We refer to them from a JOIN-ON clause and an
ORDER-BY clause.
Example code:
ColumnRef *ref;
ref = makeNode(ColumnRef);
ref->fields = list_make1(makeString("some_unique_name"));
ref->location = -1; /* Unknown location */
...
sb1 = makeNode(SortBy);
sb1->node = ref;
...
ssResult = makeNode(SelectStmt);
ssResult->withClause = NULL;
ssResult->fromClause = list_make1(joinExpr);
ssResult->targetList = list_make1(rtAStarWithR); /* input = r.* */
ssResult->sortClause = list_make2(sb1, sb2);
Is there a possibility for such column names?
Thanks for your help,
Peter