Re: [GENERAL] Join questions

2001-08-22 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > I have two related questions about joins. > One is that if you don't group with parenthesis, what order are they > done in? Left to right. A JOIN B JOIN C == (A JOIN B) JOIN C. > Will the optimizer be able to pick the better order of the two possibl

Re: [GENERAL] Join questions

2001-08-22 Thread Bruno Wolff III
On Wed, Aug 22, 2001 at 11:54:43AM -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > Bruno Wolff III <[EMAIL PROTECTED]> writes: > > I have two related questions about joins. > > The latter. See > http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/explicit-joins.html Thanks, this is what