Re: Problem using set-returning functions - Mailing list pgsql-sql

From Markus Schaber
Subject Re: Problem using set-returning functions
Date
Msg-id 4428016A.7020006@logix-tt.com
Whole thread Raw
In response to Re: Problem using set-returning functions  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: PFC
Date:
Subject: Re: Expressing a result set as an array (and vice versa)?
Next
From: Tom Lane
Date:
Subject: Re: Problem using set-returning functions