Eric Schwarzenbach wrote:
> In other words, if you have
>
> create view C select * from A join B on (A.foo = B.foo);
> create view D select * from C join E on (C.foo= E.foo);
> and you execute some select query on D, does it necessarily join A and B
> before joining the result to E, or might it decide to join B with E
> first before joining the result to A?
It may switch join order, yes.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.