Hi, Stephan,
Stephan Szabo wrote:
> It's an implementation detail. Some languages handle SRFs in a way that
> can be handled in the select list (SQL and C I think) and others do not
> (plpgsql).
Ah, that's an enlightening explanation, thanks.
> The latter will likely change at some point, although there are
> some confusing issues with SRFs in the select list as well, see the
> difference in behavior between:
>
> select generate_series(1,10), generate_series(1,5);
> vs
> select * from generate_series(1,10) g1, generate_series(1,5) g2;
I know that the SRF special semantics are ugly, and would vote for
adjacent tables to be implemented as replacement.
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org