Andrey Lepikhov <a.lepik...@postgrespro.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