Re: Question about undefinably query...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Question about undefinably query...
Date: 2007-04-10 14:46:00
Message-ID: 25975.1176216360@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message John Summerfield 2007-04-10 16:41:23 Re: A long-running transaction
Previous Message Wilkinson, Jim 2007-04-10 14:34:37 EXECUTE in a funtion to return a VIEW object ID