Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1B3A39FA339 for ; Tue, 10 Apr 2007 11:46:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26464-01-2 for ; Tue, 10 Apr 2007 11:46:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id CE0F49FB350 for ; Tue, 10 Apr 2007 11:46:02 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l3AEk1MR025976; Tue, 10 Apr 2007 10:46:01 -0400 (EDT) To: "A. Kretschmer" cc: pgsql-sql@postgresql.org Subject: Re: Question about undefinably query... In-reply-to: <20070410140526.GC7687@a-kretschmer.de> References: <20070410140526.GC7687@a-kretschmer.de> Comments: In-reply-to "A. Kretschmer" message dated "Tue, 10 Apr 2007 16:05:26 +0200" Date: Tue, 10 Apr 2007 10:46:00 -0400 Message-ID: <25975.1176216360@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/109 X-Sequence-Number: 28109 "A. Kretschmer" 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