Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> writes:
> Thanks, I have written the letter because of some doubts too. But only
> one weak point I could imagine - if someday sql standard will be changed.
Yeah, if they ever decide that LATERAL should be allowed to reference a
previous sub-query of UNION ALL, that'd probably break this. But it'd
break a lot of other code too, so I'm not going to worry about it.
I pushed the main fix to HEAD only, and the recursion checks to
all branches.
regards, tom lane