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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
