Re: WITH ORDINALITY versus column definition lists

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