Re: Implement targetlist SRFs using ROWS FROM() (was Changed SRF in targetlist handling) - Mailing list pgsql-hackers

Andres Freund <andres@anarazel.de> writes:
> ...  What we could do is to add efficient
> ROWS FROM (..) WITH ORDINALITY ORDER bY ordinality;
> support.

Hm?

regression=# explain select * from rows from (generate_series(1,10)) with ordinality order by ordinality;
              QUERY PLAN                                
 
-------------------------------------------------------------------------Function Scan on generate_series
(cost=0.00..10.00rows=1000 width=12)
 
(1 row)
        regards, tom lane