Re: Table returning functions - Mailing list pgsql-sql

From Jann Röder
Subject Re: Table returning functions
Date
Msg-id i773au$5e4$1@dough.gmane.org
Whole thread Raw
In response to Re: Table returning functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
True,
but it still allowed me to write queries that I do not know how to
express otherwise.

Am 20.09.10 01:58, schrieb Tom Lane:
> 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: Tom Lane
Date:
Subject: Re: Table returning functions
Next
From: Florian Weimer
Date:
Subject: Jagged/ragged arrays