Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Steve TDate: 2008-02-19 07:23:18
Subject: Re: SQL question
Previous:From: Phillip SmithDate: 2008-02-19 03:49:10
Subject: Re: SQL question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group