Re: SQL question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
Cc: "'Cesar Alvarez'" <c(dot)alvarezx66(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL question
Date: 2008-02-19 03:58:54
Message-ID: 21130.1203393534@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Steve T 2008-02-19 07:23:18 Re: SQL question
Previous Message Phillip Smith 2008-02-19 03:49:10 Re: SQL question