Re: Question about undefinably query...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Question about undefinably query...
Дата
Msg-id 25975.1176216360@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Question about undefinably query...  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-sql
"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:
> there was a question on #postgresql (irc-channel) from CyberDuck without
> an answer. A little example:

Multiple SRFs in a targetlist behave, um, strangely.  I think the rule
is that all are cycled until they all chance to report "done" at the
same time, so the number of result rows is the least common multiple
of the period lengths.

This is one of the reasons that SRF-in-targetlist is deprecated ...
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Wilkinson, Jim"
Дата:
Сообщение: EXECUTE in a funtion to return a VIEW object ID
Следующее
От: John Summerfield
Дата:
Сообщение: Re: A long-running transaction