Re: Question about undefinably query... - Mailing list pgsql-sql

From Tom Lane
Subject Re: Question about undefinably query...
Date
Msg-id 25975.1176216360@sss.pgh.pa.us
Whole thread Raw
In response to Question about undefinably query...  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List 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 by date:

Previous
From: "Wilkinson, Jim"
Date:
Subject: EXECUTE in a funtion to return a VIEW object ID
Next
From: John Summerfield
Date:
Subject: Re: A long-running transaction