"John D. Burger" <john(at)mitre(dot)org> 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