Hi, On 2016-05-23 09:26:03 +0800, Craig Ringer wrote: > SRFs-in-tlist are a lot faster for lockstep iteration etc. They're also > much simpler to write, though if the result result rowcount differs > unexpectedly between the functions you get exciting and unexpected > behaviour. > > WITH ORDINALITY provides what I think is the last of the functionality > needed to replace SRFs-in-from, but at a syntatactic complexity and > performance cost. The following example demonstrates that, though it > doesn't do anything that needs LATERAL etc. I'm aware the following aren't > semantically identical if the rowcounts differ.
I think here you're just missing ROWS FROM (generate_series(..), generate_series(...)) Andres -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers