join and where clause equivalent ?

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: join and where clause equivalent ?
Date: 2003-06-10 12:08:16
Message-ID: 1055246895.31783.3.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

is

"SELECT * FROM a JOIN b USING (id_a)"

fully equivalent to

"SELECT * FROM a, b WHERE a.id_a=b.id_a" ?

Which is faster ?

TIA
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Dmitry Tkach 2003-06-10 14:57:57 Re: join and where clause equivalent ?
Previous Message Dani Oderbolz 2003-06-10 11:55:10 Re: Question regarding keyword checkboxes in database design