"John D. Burger" <john@xxxxxxxxx> writes: > Anecdotally, I had a situation recently where I got different plans > depending on whether I queried a join of a view against itself, or > "macro expanded" the view by hand. I was =very= surprised at this. Me too, at least if you didn't do any hand optimization but just stuck the view definition in as a sub-select. Can you provide a reproducible case? regards, tom lane
