David Johnston <polobo@yahoo.com> writes:
> Just to clarify we are still allowing simple aliasing:
> select * from generate_series(1,2) with ordinality as t(f1,f2);
Right, that works (and is required by spec, I believe). It's what to
do with our column-definition-list extension that's at issue.
> Not sure if this is possible at this point but really the alias for the
> ordinality column would be attached directly to the ordinality keyword.
> e.g., ...) with ordinality{alias} as t(a1, a2)
This has no support in the standard.
regards, tom lane