Re: Table returning functions - Mailing list pgsql-sql

From Tom Lane
Subject Re: Table returning functions
Date
Msg-id 13671.1284940738@sss.pgh.pa.us
Whole thread Raw
In response to Re: Table returning functions  (Jann Röder <roederja@ethz.ch>)
Responses Re: Table returning functions  (Jann Röder <roederja@ethz.ch>)
List pgsql-sql
Jann Röder <roederja@ethz.ch> writes:
> Ok I now know that it really seems to do what I expected. But I still
> wonder what it does if I use two functions f() and g() that return a
> different number of rows.

You get the least common multiple of their periods.  It's ugly, and the
lack of any very sane way to define the behavior is the main argument
for deprecating SRFs in the targetlist.
        regards, tom lane


pgsql-sql by date:

Previous
From: Jann Röder
Date:
Subject: Re: Table returning functions
Next
From: Jann Röder
Date:
Subject: Re: Table returning functions