Re: Table returning functions

Поиск
Список
Период
Сортировка
От Jann Röder
Тема Re: Table returning functions
Дата
Msg-id i773au$5e4$1@dough.gmane.org
обсуждение исходный текст
Ответ на Re: Table returning functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Table returning functions
Следующее
От: Florian Weimer
Дата:
Сообщение: Jagged/ragged arrays