"John D. Burger" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to