Re: SQL question - Mailing list pgsql-novice

From Tom Lane
Subject Re: SQL question
Date
Msg-id 21130.1203393534@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL question  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
List pgsql-novice
"Phillip Smith" <phillip.smith@weatherbeeta.com.au> writes:
>>> Is it better to use "JOIN" or comma method with equal sign when doing
>>> table joins?

> I'm guessing there might be some effect on the planner as well maybe...?
> Someone smarter than me could shed some more light...

No, they're the same as far as the planner is concerned.  I'd say use
whichever seems more readable to you.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Phillip Smith"
Date:
Subject: Re: SQL question
Next
From: Steve T
Date:
Subject: Re: SQL question